Is there a way to copy a file when the file is open?
I have the following, but it will error when the file is open:
[vba]FileCopy "U:\folder\file_name.xls", "U:\folder2\file_name.xls"[/vba]
Is there a way to copy a file when the file is open?
I have the following, but it will error when the file is open:
[vba]FileCopy "U:\folder\file_name.xls", "U:\folder2\file_name.xls"[/vba]
________________________________________
The more questions I ask and the more I learn, I realize that I don't know squat!!!