Checking for open file before copying files in Excel VBA 2007

[phudgens]

I have tried both the FileCopy and fc.CopyFile methods to copy files between folders using Excel VBA 2007, both work great - unless the file being copied is already open. I can't find code that allows me to check if a file is open before trying to copy it. Does anyone know of any such code? The program will need to copy all types of files, not just XLS* files.

Thanks,
Paul Hudgens
Denver

 

[PHV]

Have a look here:

http://www.xcelfiles.com/IsFileOpenVBA.htm

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[phudgens]

That works - thanks!

Paul Hudgens
Denver