Hi Ron,
Yes please post an example. I tried to combine two VBA examples on your web
site but was not successful.
I am using WinZip.
Thanks a lot for your help.
--
Regards,
Martin
"Ron de Bruin" wrote:
> Hi Martin
>
> Create a workbook with only the sheets you want with code
> and save/zip that workbook
>
> Do you use the Winzip code or the code from the default Windows zip page
> Let me know and I will post a example
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Martin" <martin...mail.com> wrote in message news:600BEDAC-ACD7-4867-A61C-3BAC6BF72A9B...microsoft.com...
> > Hi everybody,
> > I have used Ron's (de Bruin) web page quite a lot and found it very, very
> > useful. Normally I am able to amend his code into exactly what I need. But
> > this time I am struggling. In VBA I am trying to "Zip and mail more than one
> > sheet from the ActiveWorkbook".
> >
> > Any help much appreciated.
> >
> > --
> > Regards,
> >
> > Martin
>