Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Using a Macro or VBA to save a sheet in a workbook and then emai

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

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

Resolved · Urgent Priority · Version 2007

Reply Wed 11 Jun 2008, 13:27Delegate Zehra said...

Zehra has attended:
Access Intermediate course
Access Advanced course

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

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

For upcoming training course dates see: Pricing & availability

Reply Thu 12 Jun 2008, 09:27Trainer Jacob said...

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

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

Excel articles

· The Mysteries Of Excel Explained
· How Teachers Are Using Microsoft Excel To Enhance Learning in the Classroom
· Going Against The Grain With Multiple Radio Buttons In Excel
· Creating Top Tables With Excel
· Should I Use Data Bars, Colour Scales Or Icon Sets In Excel?

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

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips