Xlusrgal

[FGM]

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.

 

[JLGWhiz]

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?

 

[Jon Peltier]

If it's any consolation, I've somehow corrupted my own xlusrgal file, and
whatever I've tried will not restore it. Even reinstalling Office (though
I've never completely wiped Office off the computer prior to the reinstall).
It's not just on one machine, but on every machine I use for business. While
I don't get the full blown Excel crash, it's probably somehow related.

- Jon

 

[Bill Renaud]

Jon wrote:
<<I've somehow corrupted my own xlusrgal file, and whatever I've tried
will not restore it.>>

You mean even deleting the xlusrgal file, and manually re-creating the
custom chart types to force Excel to regenerate the xlusrgal file?

 

[Jon Peltier]

That was one of the first things I tried. It would seem to work, Excel would
seem to save a new user defined chart type, then when I quit Excel later,
I'd get errors regarding the gallery.

- Jon