| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy file while in use
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy file while in use
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy file while in use
Hi Todd,
If this file is in use because it is open in the same instance of Excel that your code is running in you can use the Application.SaveCopyAs method to save a copy to a different location. If the file is in use by some other instance of Excel you're out of luck. You just have to wait until it's no longer being used. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy file while in use
Thanks guys.
Todd -----Original 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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data for match word from one file to another file | Excel Worksheet Functions | |||
| How do I copy a excel file into a InDesign file correctly? | Excel Discussion (Misc queries) | |||
| copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
| copy excell file to a CSV file and than to Notepad | Excel Discussion (Misc queries) | |||
Hybrid Mode
