Hi

One possible and common cause is bad programming. If an VB program (or a
macro) opens access to a specific filename "as #1" and don't close it again,
the next attempt to open "#1" and/or open this filename will err just like
that.

If this is the cause, it's fixed by changing the VB code a little.

HTH. Best wishes Harald

"rango316 - ExcelForums.com"
skrev i melding ...
Hi,

I recieve the above error when moving data from one excel file to
another...but only onthe second move of data...the first time i do it
works fine. The only way to do a second move of data is to reboot my
pc. It says its a Visual Basic error. I have read somewhere that it
my be a sharing violation ie it thinks im connected to this file from
my first move of data...is this correct?

Any ideas how to stop this VB error?
---------
www.coffeecozy.com

Use your Bodum and give up cold coffee for good!