Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy foo.xls whilst it's opened by Excel - are there problems ?
Hi - I want to develop a program to repeatedly copy a Workbook file
whilst it's opened by Excel (let's say it will do it every 10 seconds). I've tried this out myself (doing the copies 'by hand' ) and there doesn't seem to be a problem but are there circumstances in which my program would not be able to complete the copy ? I know you cannot delete a file which Excel has open. Is there anything I should be concerned about where I setup a process which repeatedly copies an Excel workbook which is in use by Excel ? thanks richard. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy foo.xls whilst it's opened by Excel - are there problems ?
It shouldn't be a problem to copy the file.
But beware, that the file only contains the data since the last save! hth Carlo On Dec 21, 12:51*pm, northof40 wrote: Hi - I want to develop a program to repeatedly copy a Workbook file whilst it's opened by Excel (let's say it will do it every 10 seconds). I've tried this out myself (doing the copies 'by hand' ) and there doesn't seem to be a problem but are there circumstances in which my program would not be able to complete the copy ? I know you cannot delete a file which Excel has open. Is there anything I should be concerned about where I setup a process which repeatedly copies an Excel workbook which is in use by Excel ? thanks richard. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VB to make a copy of opened file | Excel Programming | |||
Macro in Excel causes problems when spreadsheet is opened in IE | Excel Programming | |||
Is there away to keep Excel from opening a copy of an already opened workbook and the pages not be at 100% but | New Users to Excel | |||
Problems with Copy and Paste in Excel | Excel Worksheet Functions | |||
stop excel file opened as read only if already opened by another u | Excel Programming |