Using a Macro or VBA to save a sheet in a workbook and then emai

The UK's most regular instructor-led training courses.
Training information: excel+training · Excel training course · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Urgent Priority · Version 2007

Zehra has attended:
Access Intermediate course
Access Advanced course

by - delegate Zehra [3 posts] (2008 Jun 11 Wed, 13:27) Reply

Hi

I need to create a macro which will save the current active worksheet as a seperate file.
Then I need this seperate file to be automatically added to an email and sent to a pre-designated person.

I have tried using hyperlinks to do this but all I can do is generate an email but I cant attached the sheet in question.

Please can you advice this is very important

Thanks

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 12 Mon	Bayswater	3	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	1	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
2007	2009 Jan 20 Tue	Bloomsbury	3	book now	£224	£224
2003	2009 Jan 20 Tue	Southwark	4	book now	£207	£215
Full Schedule: See all 134 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: Using a Macro or VBA to save a sheet in a workbook and then

by - trainer Jacob gold contributer [124 posts] (2008 Jun 12 Thu, 09:27) Reply

Hi Zehra

Thanks for your post. By what you describe we may be able to help you with this in the form of consultancy work.

To ensure a successful outcome, we:

Identify the key objectives with you
Assign the most suitable trainer/consultant
Estimate the scope of work required
Agree final costing and description of work
Arrange suitable dates and development time (if required)

If you wish to progress this further, please let us know.

Regards

Jacob

· Why Should I Learn Visual Basic in Excel?
· How to Create Better Excel Spreadsheets: Part Two
· Benefits of learning about Excel charts
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Microsoft Excel Courses Teach Advanced Macro Techniques

Please browse our web site to find out more about
excel+training and other Microsoft training courses.

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

View all Excel hints and tips

Rate this page: