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.

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 <shearich...@gmail.com> 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.