workbooks("Test.xls").SavecopyAS "C:\Bye\Test.xls"

--
Regards,
Tom Ogilvy

"Todd Huttenstine" wrote in message
...
Hey guys

How do you programmatically copy a file while its in use?

Lets say the file is "Test.xls". Test.xls is located in
C:\Hey directory. This is the open file. I want to copy
it from C:\Hey to C:\Bye.


How would I do this?

Thanks
Todd Huttenstine