Copy file that is open

[Excelownik]

Dears,

Do you know How to copy file in VBA if the file is open?
FileCopy doesn't work

Have a good day.

Piotr

 

[Takae]

Why don't you save it a different name?

 

[dmt32]

Hi,
Use SaveCopyAs Method

ActiveWorkbook.SaveCopyAs "C:\My Documents\MyFile.xlsx"

This saves a copy of the workbook to a file but doesn't modify the open workbook

Note you are not able to change the file format using this method

Hope Helpful

Dave

 

[Excelownik]

Hi
Thanks it's working if I have opened workbook.
But situtation is that the workbook I would like to open, is already opened by someone else in shared company disk.
FileCopy "K:\FOLDER1\file1.xlsx, "Z:\FOLDER2\file1.xlsx" doesn't work, if at the moment of copying someone opened this workbook.

Best Regards,

Piotr