F
FlawedLojik
While running a VBA macro, Excel 2000 creates charts of its own which only
appear in the "Project Explorer" of the file. [It is interesting to note
that the longer the code runs (i.e. days) the more charts Excel has created.]
The moment Excel creates these "hidden charts," the file can no longer have
a copy made (via SaveCopyAs or any other means) without this copied file
causing that instance of Excel to crash because the file is corrupt.
And therefore, the moment Excel creates these "hidden charts," you need to
rebuild the file that just went corrupt. However, the "corrupt" file can
still run while it is open, but it will be corrupt if the user closes it.
(Lesson: Don't close the file)
Can anyone help me figure out what it is about my code that might cause
this? Has anyone ever seen this before?
Because I am sick and tired of having to rebuild my code when someone else
closes the file.
appear in the "Project Explorer" of the file. [It is interesting to note
that the longer the code runs (i.e. days) the more charts Excel has created.]
The moment Excel creates these "hidden charts," the file can no longer have
a copy made (via SaveCopyAs or any other means) without this copied file
causing that instance of Excel to crash because the file is corrupt.
And therefore, the moment Excel creates these "hidden charts," you need to
rebuild the file that just went corrupt. However, the "corrupt" file can
still run while it is open, but it will be corrupt if the user closes it.
(Lesson: Don't close the file)
Can anyone help me figure out what it is about my code that might cause
this? Has anyone ever seen this before?
Because I am sick and tired of having to rebuild my code when someone else
closes the file.