View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default can't save my file with macro

That's a lot of bytes!

I'd try running Rob Bovey's code cleaner.
You can find it he
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 wrote:

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