Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I need to zip a file that I am working on, then email
automatically. I can do the emailing bit, but can't do the zip The OS is XP professional, with Office 2003 PS I know it can be done under WinZip, but I need the code for the OS default Zip Many thanks in advance John |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi,
I have been looking for the way to use the XP default zip also, but with no success. I found two other alternatives though: -1- have VBA called microsoft's "compress.exe" program (free) to do compression. -2- automate the whole process by writing a code behind for the office file using "Visual Studio Tools for Microsoft Office"; the code behind can call "SharpZipLib" (free) to do compression. hope this helps, "JohnUK" wrote: Hi, I need to zip a file that I am working on, then email automatically. I can do the emailing bit, but can't do the zip The OS is XP professional, with Office 2003 PS I know it can be done under WinZip, but I need the code for the OS default Zip Many thanks in advance John |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I never try it with Win XP zip
See my site for examples for winzip http://www.rondebruin.nl/zip.htm And a add-in http://www.rondebruin.nl/mail/add-in.htm -- Regards Ron de Bruin http://www.rondebruin.nl "JohnUK" wrote in message ... Hi, I need to zip a file that I am working on, then email automatically. I can do the emailing bit, but can't do the zip The OS is XP professional, with Office 2003 PS I know it can be done under WinZip, but I need the code for the OS default Zip Many thanks in advance John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel |