Excel / VBA "Out of Memory" message. 1

[Pyrrhus]

I have a largish workbook of 100 or so sheets / charts. When I try to open VBA to check on properties / code, I get an "Out of Memory" message. Takes half a dozen clicks on "OK" to get the message box to disappear. Worked OK previously, so I'm suspicious there's some corruption somewhere. Running Win 98 / Excel 2000 with 256 megs. Does anyone have any thoughts on what might be the problem, and how to get out of it? Please.

 

[Dreamboat]

If you know someone with Excel XP, it has greater "de-corruption" capability and can actually fix your file. If you don't know someone, zip and ship to Anne@TheOfficeExperts.com. I also am testing out some "de-corruption" software, so that'd be way cool for me too. All information strictly confidential. Anne Troy

http://www.TheOfficeExperts.com

 

[Pyrrhus]

Anne,

Thanks for your offer of help. I'm sending the Excel workbook right now. Checked out your site. Looks interesting.

Thanks for your help. I'm feeling somewhat happier now.

 

[Dreamboat]

Well. I had no problem with your file at all. I'll make the following suggestions STRONGLY:



Clean up your hard drive as described:

http://www.theofficeexperts.com/cleanyourpc.htm

KEEP your temp folder cleaned out regularly as described there (just the start-run %temp% thing and deleting the files therein) particularly when working with VBA files alot.

Instead of using all those controls to go to other worksheets, create hyperlinks. They're MUCH easier, don't require all that heavy coding... Make a textbox, or just put the items right in cells, format them nicely, and create hyperlinks to those worksheets. When you create the hyperlinks, you'll find your cell references already there.

Let me know if you need more help with it. Do you want the file saved in XP and sent back? Anne Troy

http://www.TheOfficeExperts.com

 

[Pyrrhus]

Wow! That was quick, Anne.

Thanks very much for your advice. I'll follow all the suggestions. It might be helpful to get the file back in XP format, since you offered. Much appreciated.

Worth at least a star (and a medal). Thanks again.

 

[Dreamboat]

Thanks! I did send your file just a minute ago, and also added some sample hyperlink methods for you to check out.

You can also assign code to text boxes and graphics, so you can really make all your menus look a little snazzy if you want. I use Photodraw to create those objects, like the little graphic sample I sent, but you can use plain-old Office drawing tools. Autoshapes like a Back and Next arrow...etc.

If I were you, I might take those charts and put them ON those sheets instead of as chart sheets. Then, you can add next/back buttons, or practically complete menus and keep everyone out of your sheet tabs...I could go on and on. LOL Anne Troy

http://www.TheOfficeExperts.com

 

[Pyrrhus]

Thanks again Anne. Your last post was really helpful again. As you can tell, my knowlege of Excel is fairly basic, and you've given me the suggestions and encouragement to go much further into it and brush up the application considerably.

I really appreciate you taking the time!

 

[Dreamboat]

No problem. Feel free to ask if you have any more Qs. Anne Troy

http://www.TheOfficeExperts.com