Zip workbook

[John]

Hi,

Can someone help me create a code that zip, send and than
mail (attached the zipped file) workbook to several
recipients?

Regards

 

[Norman Harker]

Hi John!

See:
Ron de Bruin:
http://www.rondebruin.nl/sendmail.htm

 

[John]

Hi Norman,

That is what I have tried to begin with.
I am getting an error in the following:

'Zip the file
ShellStr = PathWinZip & "Winzip32 -min -a" _
& " " & Chr(34) & FileNameZip & Chr(34) _
& " " & Chr(34) & FileNameXls & Chr(34)
ShellAndWait ShellStr, vbHide

I am using this Unregisterd WinZip(R) Version 8.1?

saving the file is also not working and attaching the file
is also not working.
I am using Window 2000 and MS Oulook 2000.

Regards,

 

[Tom Ogilvy]

On the page at Ron's site it says:

The examples are only working If you use WinZip as your Zip program.(Note:
you must have a registered copy of WinZip)

 

[Michael Bednarek]

Hi Norman,

That is what I have tried to begin with.
I am getting an error in the following:

'Zip the file
ShellStr = PathWinZip & "Winzip32 -min -a" _
& " " & Chr(34) & FileNameZip & Chr(34) _
& " " & Chr(34) & FileNameXls & Chr(34)
ShellAndWait ShellStr, vbHide

I am using this Unregisterd WinZip(R) Version 8.1?

AFAIK WinZip32 does not support any command line switches - its command
line adjunct, WzZip, does; to avoid nag messages you probably need the
registered version, or a dfifferent free console zip program.

 

[Norman Harker]

Hi John!

You've got the reason and bad news from Tom and Michael.

You may have noticed with your unregistered version that it opens
differently each time.

Although, the WinZip mailing process requires a Registered version of
WinZip, this does not impact upon the ability of receivers to use an
unregistered copy of WinZip to on zipped files.

 

[David McRitchie]

If you got UltimateZip (free for noncommercial home use)
http://www.ultimatezip.com/index.htm
hthttp://www.ultimatezip.com/download.htm

you would simply right-click on the file in Explorer, no special proprietory
GUI interface, and email it.
Zip and E-mail "filename".zip
you do not need to use VBA to help you do anything
But if you did it does have batch commands.

Backup to CD by zipping personal folders (#backupto_CD)
http://www.mvps.org/dmcritchie/excel/backup.htm

 

[David McRitchie]

I was looking through UltimateZip stuff, 2.7.1 the current version does
not support batch files after all (the author indicated in a forum that they
were working on it). There is a 3.0 Beta available, don't know if it has
batch processing or not (for myself, I don't care).