Hi,
I am trying to save a specific worksheet called "Status" as a separate workbook (xlsx) in a specific folder. In the new workbook all filled in cells should be formated as values so there are no formulas.
Can you please provide me with a VBA code which solves this issue?
Thank you so much in advance.
Code below saves file named "ChosenName" to folder D:\Documents\ABC\"
Also (commented out) options to use the same folder as the current file or to name the file with the sheet name (= Status)
Put this code in a general module and run from Sheet
Please Login or Register to view this content.
If a response has helped then please consider rating it by clicking on *Add Reputation below the post
When your issue has been resolved don't forget to mark the thread SOLVED (click Thread Tools at top of thread)
It works. Thanks a lot.
You are welcome. Thanks for the reps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks