Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't save my file with macro
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't save my file with macro
Tnks it seems to work with after code cleaner
"Dave Peterson" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Macro to Open File, Delete Contents, Save New File | Excel Discussion (Misc queries) | |||
Macro to save Excel file with date and time in the file name? | Excel Programming | |||
Macro Save File (Unique file name) | Excel Worksheet Functions | |||
Macro to insert values from a file and save another sheet as a .txt file | Excel Programming | |||
Automate open file, update links, run macro, close and save file | Excel Programming |