A AC Apr 9, 2009 #2 Hi How can I copy a file to a path via vba? Thanks Regards Click to expand... Hi. You can use the "FileCopy" statement Syntax: FileCopy strSource, strDestination strSource = string with full path and file name strDestination = string of destination folder Make sure you check the file you are copying is closed, if you try to use the FileCopy statement on a currently open file, an error occurs. HTH AndyC
Hi How can I copy a file to a path via vba? Thanks Regards Click to expand... Hi. You can use the "FileCopy" statement Syntax: FileCopy strSource, strDestination strSource = string with full path and file name strDestination = string of destination folder Make sure you check the file you are copying is closed, if you try to use the FileCopy statement on a currently open file, an error occurs. HTH AndyC
