Home » Category » Microsoft Excel

Microsoft Excel: Zip workbook

205| Fri, 23 May 2008 07:13:00 GMT| anonymous| Comments (7)
Hi,

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

Regards

Keywords & Tags: zip, workbook, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495132/
 
«« Prev - Next »» 7 helpful answers below.
Hi John!

See:
Ron de Bruin:
http://www.rondebruin.nl/sendmail.htm
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker...optusnet.com.au

norman | Fri, 23 May 2008 07:14:00 GMT |

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,

>--Original Message--
>Hi John!
>See:
>Ron de Bruin:
>http://www.rondebruin.nl/sendmail.htm
>--
>Regards
>Norman Harker MVP (Excel)
>Sydney, Australia
>njharker...optusnet.com.au
>
>.
>

john | Fri, 23 May 2008 07:15:00 GMT |

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)
-- Regards,Tom Ogilvy"John" <anonymous...discussions.microsoft.com> wrote in
message news:2bad301c4680c$4cf4e2b0$a301280a...phx.gbl...
> 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,
>
> >--Original Message--
> >Hi John!
> >
> >See:
> >Ron de Bruin:
> >http://www.rondebruin.nl/sendmail.htm
> >
> >--
> >Regards
> >Norman Harker MVP (Excel)
> >Sydney, Australia
> >njharker...optusnet.com.au
> >
> >
> >.
> >

tom | Fri, 23 May 2008 07:16:00 GMT |

On Mon, 12 Jul 2004 05:32:31 -0700, "John"
<anonymous...discussions.microsoft.com> wrote in
microsoft.public.excel.programming:

>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.

>saving the file is also not working and attaching the file
>is also not working.
>I am using Window 2000 and MS Oulook 2000.
>>--Original Message--
>>Hi John!
>>See:
>>Ron de Bruin:
>>http://www.rondebruin.nl/sendmail.htm
--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

michael | Fri, 23 May 2008 07:17:00 GMT |

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.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker...optusnet.com.au

norman | Fri, 23 May 2008 07:18:00 GMT |

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

--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"John" <anonymous...discussions.microsoft.com> wrote in message news:2b17501c46800$5f0e5500$a401280a...phx.gbl...
> Hi,
> Can someone help me create a code that zip, send and than
> mail (attached the zipped file) workbook to several
> recipients?
> Regards
>

david | Fri, 23 May 2008 07:19:00 GMT |

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).

david | Fri, 23 May 2008 07:20:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories