Macro modules have vanished

[CraigB]

I'm seeing some rather curious behaviour from a template (.dot) file
that should contain a whole bunch of VBA code modules. Getting a list
of macros in the template through the Macro dialog shows all the macros
that should be available. However, when I open the VBE, there's no sign
of even the project for the document (all I can see is Normal). On
opening the template I get an "Issufficient memory" error.

I know it's not a memory problem, and the MS solutions about a corrupt
Normal.dot or VBE.dll runtime problem don't make sense as the template
behaves the same way on multiple different machines. I have other
templates which are near identical and don't have this problem so it
seems restricted to this template itself.

Is is just corrupt and I should give up on it, or is there anything
that might explain this behaviour?

Thanks in advance

Craig

 

[Word Heretic]

G'day "CraigB" <[email protected]>,

Close Word
Open the template explicitly
Alt+F11, Ctrl+G (VBE, Immediate WIndow)

Enter:

? Activedocument.vbproject.vbcomponents.count

If this is > 0 you can programmatically access your modules - the VBA
code cleaner would help with this.


Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


CraigB reckoned: