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.
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.