Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » training excel vba - Zipped Files again
training excel vba - Zipped Files again
Resolved · Low Priority · Version Standard
Paula has attended:
Excel VBA Intro Intermediate course
Zipped Files again
hi -
is it possible to email files i have already zipped as part of a macro.
and is it possible to zip a file in a macro (or use Microsoft compressed file format)?
thanks
For upcoming training course dates see: Pricing & availability
RE: Zipped Files again
Hi Paula
the Office Developer Center might be of assistance here. Take a look at this section which details how to create an email with attachment.
https://msdn2.microsoft.com/en-us/library/aa210901(office.11).aspx
Along the same lines you will see a discussion on msdn around the topic of creating compressed folders using vba.
https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=692917&SiteID=1
I hope this is helpful.
Kind regards,
Andrew
|
|
