how to copy and send excel file 2007 to hotmail customers

B

billwoaks

How can I save an excel 2007 file attachment and then send or forward to
hotmail customer
 
M

Murph

Ron
The Email code is a great help.
Is there code to add it to a compressed file before sending?
 
M

Murph

In rowsing Ron's site I have found the zip code so will try to adapt for my
purposes.
Very helpful site Ron.
Thank you!
 
M

Murph

Using Ron's code to try zipping an xls worksheet, namely:
'Sub Zip_ActiveWorkbook()
Dim strDate As String, DefPath As String
Dim FileNameZip, FileNameXls
Dim oApp As Object
Dim FileExtStr As String


'Create empty Zip File
NewZip (FileNameZip)"

A compile error occurs: Sub or Function not defined.

Is the function available in Excel 2007?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Excel address book to Word for subsequent use with MSN Hotmai 1
trouble downloading 2003 excel file 1
Hotmail Email forwarding 15
Excel 2007 to 2003 conversion 2
Embedding an Excel 2007 worksheet into an email without attaching 2
excel attachments 1
send single worksheet from excel 2007 2
Email worksheet from Excel 2007 2

Top