Looking to make a copy of open workbook and save as it to a specific folder without any of the formulas/macros from the original.
I keep have trouble onThis is the full code:
Please Login or Register to view this content.
Please Login or Register to view this content.
What's the value of Filename? Does it look like a valid path?
Entia non sunt multiplicanda sine necessitate
This is the destination to which I want to save the "saved as" flattened file in.Please Login or Register to view this content.
the 4xx is just for the thread, the workbook name will always be a 3-digit number like 234.xlsx
Last edited by JPSIMMON; 10-27-2015 at 01:02 PM.
Not my question.Originally Posted by JPSIMMON
After this statement executes:
... what is the value of the variable Filename?Please Login or Register to view this content.
Sorry shg,
"4XX Original.xlsx" is the name of the original workbook, is that what you mean?
SHG, you were right I have an invalid path for FileName.
Essentially I just need to know where to put the destined location to save my new flattened file
So where do you want to save it?
This is the destination folder:
Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks