can't save my file with macro

[perellano]

Hello everyone

I'm working with Excel 2000. Now there's a lot of macros I've made on it and
later on I want to save it as a xla(plugin) file.

When I do that(save file) sometimes my Excel 2000 crashes. Or sometimes I
can save it but then can't open it agean. Currently it has as size of
2180kBytes only VBA-Codes. I think I'm now on the limit of Excel 2000.

With Excel 2003 it seems to work.

Does anybody have the same experience? Is there any patches or something?

 

[Dave Peterson]

That's a lot of bytes!

I'd try running Rob Bovey's code cleaner.
You can find it here:
http://www.appspro.com/
or directly
http://www.appspro.com/Utilities/CodeCleaner.htm

If that doesn't help, I'd start a new workbook and drag all the
modules/userforms/etc to the new workbook's project.

Then save that new workbook as the addin.

Each version of excel seems to be sensitive to different things when it comes to
corruption. Maybe xl2003 is more forgiving in this case.

 

[perellano]

Tnks it seems to work with after code cleaner

That's a lot of bytes!

I'd try running Rob Bovey's code cleaner.
You can find it here:
http://www.appspro.com/
or directly
http://www.appspro.com/Utilities/CodeCleaner.htm

If that doesn't help, I'd start a new workbook and drag all the
modules/userforms/etc to the new workbook's project.

Then save that new workbook as the addin.

Each version of excel seems to be sensitive to different things when it comes to
corruption. Maybe xl2003 is more forgiving in this case.