Dear All,
I found the below code for to
Saveas ActiveSheet from page 1 to 1 at the location D:\SB TYRES\Excel\Day Sheets\
with file name referencing to Range "B1"
There is a date in B1 (like this format 17-02-2017).
I want the file name as exact B1.
It's not working and macro being stopped at the save as dialogue box. (and also showing the different location).
Any help be appreciated.
Thanks in advance.
Similar Question has been asked in other forum. Click here to refer
Please Login or Register to view this content.
Bookmarks