training excel vba - Zipped Files again

The UK's most regular instructor-led training courses.
Training information: training excel vba · Excel training course · Microsoft Office VBA training

Resolved · Low Priority · Version Standard

Zipped Files again

Paula has attended:
Excel VBA course

by - delegate Paula [2 posts] (2007 Aug 13 Mon, 09:17) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	6	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Zipped Files again

by - trainer Andrew platinum contributer [513 posts] (2007 Aug 13 Mon, 15:53) Edited on 2007 Aug 13 Mon, 15:54 Reply

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

· MS Excel: Excel At Making The Most Of Your Christmas
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Tips for Transitioning to Excel 2007
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Why Should I Learn Visual Basic in Excel?

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips