File Error Data May Have Been Lost

T

trthompson

I am receiving the error "File Error Data May Have Been Lost". No data is
being lost. Is there a way to supress this message.
The error occurs when the file is opened but does not appear everytime the
file is opened. When it appears it may come once, or multiple times in
succession. I have had to accept it as many as four times before the next
line of code would execute.

Details--

I have written a fairly complex workbook used for SPC control. The control
system is separated into primarily two pieces. A template stored as an .xls
file & code stored as .xla. The .xla file is referenced by each workbook that
was created from the template . Each workbook executes some code from the
ThisWorkbook object on Open then turns control over to the .xla side. There
is additional code executed with the BeforeClose command. During execution
of the code in the .xla file, additional .xls files are opened, data is
copied, pasted into the originally opened workbook & the support files are
closed again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top