Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Zip & Email - VBA

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Zip & Email - VBA

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Zip & Email - VBA

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Macro how to create email link for the email addresses in aRange or Selection Satish[_2_] Excel Worksheet Functions 8 December 28th 09 03:30 PM
send wkbk as an email attachment with an email address copied from SueInAtl Excel Discussion (Misc queries) 0 May 21st 07 10:53 PM
can I copy a column of email addresses, paste into email address? Lizizfree New Users to Excel 4 July 20th 06 10:03 PM
Transfer Email addresses from spreadsheet to email address book Beana Excel Discussion (Misc queries) 2 May 30th 06 06:07 PM
Email editor closes when forwarding Excel-embedded email Bambina Setting up and Configuration of Excel 0 March 16th 06 10:45 PM


All times are GMT +1. The time now is 03:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"