Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
'Out of stack space' error on SaveAs
I recently got a new machine with and am trying to run some existing
Excel VBA code. I have two problems: - When I try to save a project I get an 'out of stack space' error. - When I try to load an .xla I get an 'compile error: automation error' on a simple declaration line: Public gAMGMenu As CommandBarPopup The problems are a mystery since everything worked OK on my previous machine and it works on other peoples machines who have the same tools as I. It has been suggested that maybe the Excel/VBA installation is corrupt and needs to be reinstalled. The enviroment is: - Windows XP Pro 2002 SP 2 - Excel 2002 10.2614.2625 - Visual Basic 6.3 . VBA 6.3.8863 . Forms3 2.01 . Version: 9108 Any tips are appreciated. Thanks! -- Tim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
'Out of stack space' error on SaveAs
- When I try to load an .xla I get an 'compile error: automation error'
on a simple declaration line: Public gAMGMenu As CommandBarPopup In the VB editor: ToolsReferences - Are any of the checked references marked as "MISSING"? try unchecking & then rechecking them. Then DebugCompile. - Do you have a checked reference for "Microsoft Office x.x Object Library"? (that's where CommandBars live) HTH, -- George Nicholson Remove 'Junk' from return address. "Tim" wrote in message oups.com... I recently got a new machine with and am trying to run some existing Excel VBA code. I have two problems: - When I try to save a project I get an 'out of stack space' error. - When I try to load an .xla I get an 'compile error: automation error' on a simple declaration line: Public gAMGMenu As CommandBarPopup The problems are a mystery since everything worked OK on my previous machine and it works on other peoples machines who have the same tools as I. It has been suggested that maybe the Excel/VBA installation is corrupt and needs to be reinstalled. The enviroment is: - Windows XP Pro 2002 SP 2 - Excel 2002 10.2614.2625 - Visual Basic 6.3 . VBA 6.3.8863 . Forms3 2.01 . Version: 9108 Any tips are appreciated. Thanks! -- Tim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
'Out of stack space' error on SaveAs
Nothing is MISSING and I have the MS Office 10 0 Object Library.
Recompile causes VB and Excel to die. Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
'Out of stack space' error on SaveAs
Problem solved.
I reran the Office installation having it detect and repair problems. It ran quickly and the only noticeable affect was that it was registering types. The problem .xla loads just fine and compiles without errors. Don't know what the problem was. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Out of Stack Space error | Excel Discussion (Misc queries) | |||
Out of Stack space - run time error 28 | Excel Discussion (Misc queries) | |||
Out of space stack error, simple code? | Excel Programming | |||
Out of Stack Space error | Excel Programming | |||
Run time error 28: Out of stack space | Excel Programming |