Hi all,
I have the following code to attach a workbook to an email and send it. I want to add in a step to enable the user to save the workbook to a location of their choice. The workbook will be used by various users outwith my department/company so I can't hard code a location. I do want to hardcode the file name if possible, if not then I would want the save as box to pop up AFTER the email has been sent.
Thanks in advance
Please Login or Register to view this content.
Hello Maleficent,
This will let you choose the folder to save the copy to. The workbook file name is still hard coded.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Works perfectly!! thanks so much Leith Ross
Hello Maleficent,
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks