Copy file that is open

Excelownik

New Member
Joined
May 15, 2017
Messages
7
Dears,

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

Have a good day.

Piotr
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Hi,
Use SaveCopyAs Method

Code:
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
 
Last edited:
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,216,075
Messages
6,128,665
Members
449,462
Latest member
Chislobog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top