'Out of stack space' error on SaveAs

[Tim]

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!

 

[George Nicholson]

- 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: Tools>References
- Are any of the checked references marked as "MISSING"? try unchecking
& then rechecking them. Then Debug>Compile.
- Do you have a checked reference for "Microsoft Office x.x Object
Library"? (that's where CommandBars live)

HTH,

 

[Tim]

Nothing is MISSING and I have the MS Office 10 0 Object Library.

Recompile causes VB and Excel to die.

Thanks!

 

[Tim]

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.