98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Applying and removing border from cell in Excel 2010Did you know the shortcut key for applying and removing the outline border for a cell? |