Why don't you post the part of your code that closes the files and ends the
program so we can take a look to see if there is any identifiable glitch.
Also, is any part of your program written in the old XL4 macro code or is it
all in
VB?
"FGM" wrote:
Windows 2000
excel 2002
I have a group of macros that I run on several xls files.. might have 10 -
20 files open at once. In some of my macros I create charts using
ActiveChart.ApplyCustomType ChartType:=xlUserDefined, TypeName:= _
"CEL-dBA Chart"
chart TypeName differs.
The macros work and everything I want gets created ...
The problem comes when I close the files. I get the error message "Send
Error Message to Microsoft" Then Excel closes and reopens with the
Xlusrgal.xls as being the problem file.
I have always just exited out of excel and not restored the Xlusrgal.xls and
all is well. However, I am tired of this message always coming up. I
believe it started being a problem when I switched to Excel 2002 from 95.
Any suggestions would be most appreciated.
thanks.