Dear Pro,
I reordered following macro. I would like the file to be save in the name indicate in cell M1.
The name in cell M1 will change every time when the file extracted.
Is they anyway to do it?
Appreciate your help!
Please Login or Register to view this content.
What do you have, exactly, in cell M1?
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
If I understand correctly, if you have in M1 the workbook name(like ABC.xlsx), the following code will save the workbook in the specified folder with the name from M1.
Make sure to delete the row that contains Selection.ClearContents because it will delete the content of M1
HTML Code:
That's awesome!! TQVM!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks