Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / February 2005

Tip: Looking for answers? Try searching our database.

Macro modules have vanished

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CraigB - 15 Feb 2005 10:19 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.