98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
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
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
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Display Formulas Instead of Results in Excel 2010By pressing Ctrl ~ once, Excel will display formulas rather than the results of the formulas. Press it again, and the results will appear again. |
