using macro vba save

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

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

resolvedResolved · Urgent Priority · Version 2007

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

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

 

Training courses

 

Training information:

See also:

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Applying and removing border from cell in Excel 2010

Did you know the shortcut key for applying and removing the outline border for a cell?

CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT_ Removes the outline border from the selected cells.

View all Excel hints and tips


Server loaded in 0.08 secs.