Exporting Macro
Hi, I currently have the below Macro exporting a sheet from Excel. However whereas at present the macro exports the sheet with a specific name and saves to the H Drive. I would like the macro to export with the same naming arrangement, but ask where to save.
Please help.
Please Login or Register to view this content.
Try this
- allows you to specify a default path, which is then placed in an input box for user to amend
replace:
with:Please Login or Register to view this content.
Please Login or Register to view this content.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Hi,
Unfortunately that doesn't really solve my problem. I would like the Macro Button to export the sheet, but bring up teh Save As box, so we can visually choose which folder to save it in. See attached.
Is this possible?
Capture 1.PNG
Regards,
Chris
Last edited by christoph13; 02-20-2017 at 12:11 PM.
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Correction:
Please Login or Register to view this content.
Hi,
Thats much better. However it isnt bringing through the file name as below:
Capture 2.PNG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks