I want to open an existing workbook, make a copy, rename the copy only and have it remain open and retain the original workbook unchanged and not open.
I want to open an existing workbook, make a copy, rename the copy only and have it remain open and retain the original workbook unchanged and not open.
Change the path, file name and extension in the below code
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi, JJGF,
the SaveAs command should work as expected:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thanks, I used your code and modified a bit:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks