training excel vba - zipped files again
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

resolvedResolved · Low Priority · Version Standard

replyReply Mon 13 Aug 2007, 09:17Delegate Paula said...

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

replyReply Mon 13 Aug 2007, 15:53 Edited on Mon 13 Aug 2007, 15:54Trainer Andrew said...

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

 


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard