Save Copy Of Workbook & Keep Both Open (Original and copy)

Hello,

I am using this macro code for creating copy of my Excel file. I would like to update this code and keep both files opened (original and also new copy), because I need to make some changes in newly copied file and after that save it again.

Could you pls help me write down Action 1. & 3. in following code?

Please Login or Register  to view this content.

Hi Keebellah,

unfortunately, it doesn't work as I expected. You defined original workbook as source file and in next step you initiate its opening. However this file is always opened. What I need is to open created copy.

Hmmm, looks better, however doesn't work due to:

Run-time error '1004': Excell cannot open the file '641_CB_data_2017_10.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

It looks, that your macro works perfectly, but problem is with created copy in this this part of macro. I am not able to open it manually too.

Please Login or Register  to view this content.

There is omitted File format:=52, because it didn't work and I didn't realize it before, that created copied is not active file.

Thank you very much, my friend.
Meantime I tried to write down more simple way and it looks, that it works.

Please Login or Register  to view this content.