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 - 17 Feb 2005 04:17 GMT
G'day "CraigB" <kaldvelski@yahoo.co.uk>,
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:
>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
[quoted text clipped - 15 lines]
>
>Craig