Hello,
Please, is posible to perform this action? (save as, close and again open with one VBA script)
Description:
1) You have file: "test1.xlsm".
2) You will do some changes and save them.
3) You will save file as "test2.xlsx"
4) after it you close ActiveWorkbook.Close SaveChanges:=False
5) I need open "test1.xlsm" again. And here I have problem, the workbook is not opened
And aplication excel is without workbook.
Thank you in advance for advice.
Regards.
Martin
Bookmarks