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

using macro vba save

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

ResolvedVersion 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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.