I wonder whether you're confusing VB6 and VBA.

If you are referring to VB6, did your automation properly shut down the
instance of Excel used when creating the workbook? If not, there may be a
hidden instance of Excel, which has a copy of the file open. Look in the
Task Manager for extra EXCEL.EXE processes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"htrajt" wrote in message
...
I receive this message nearly every time I open a modified and previously
saved file on my drive only. The excel files when I get this message are
usually outputs of my own modules that are created by Microsoft Visual
Basic
6.0 under the Visual Basic Editor toolbar. Sometimes both the excecl file
that creates the outputs of the modules gives me the read only message,
and
also the outputs themselves give me the message. I've wondered if Norton
is
hanging onto the files for moments after being created? and that is why I
get
the message? If I click cancel, then I can just double click the file
again
to open and it always opens the second time without the message. This is
not
a matter of checking properties on the file, because I am constantly using
the excel file with the programmed code in the modules, and the outputs
are
new creations coming out of the modules as outputs.
Title bar of dialog box reads "File in Use"
Luxd-sum.xls is locked for editing
By "owner"
Click Notify to open a read-only copy of the document and receive
notification when the document is no longer in use.
Click choices
Readon only
Notify
Cancel