nothing works to initialize Word application object from class module

[richardconers]

I've using Word XP. I'm trying to initialize an Application object
created in class module but nothing i've tried works. [when i
manually initialize the object, the procedure in the class module
works fine until I close down Word--i just can't get the initialize
code to work. So rather than test the initialize code, I went for
something simple to test whether AutoExec was firing (which it
wasn't).

Here's what I've tried to test making an AutoExec work:

In a regular module in the Normal template, I've got a module named
"AutoExec" and a procedure called Main:

Public Function Main()
MsgBox "autoexec works"
End Function

it didn't work.

I deleted that "AutoExec" module and then in another regular module I
have this code:

Public Function autoexec()
MsgBox "autoexec works"
End Function

it didn't work.

Then i tried a startup switch in the Run menu of Windows :
"C:\Program Files\Microsoft Office\Office10\WINWORD.EXE/mautoexec"

It didn't work. I got an error saying that Windows couldn't find the
path.

Anything else I can try????
Thanks!!!!!!

 

[Russ]

http://support.microsoft.com/kb/210565
http://wordprocessing.about.com/od/customizingword/qt/AutoExecMacro.htm

I've using Word XP. I'm trying to initialize an Application object
created in class module but nothing i've tried works. [when i
manually initialize the object, the procedure in the class module
works fine until I close down Word--i just can't get the initialize
code to work. So rather than test the initialize code, I went for
something simple to test whether AutoExec was firing (which it
wasn't).

Here's what I've tried to test making an AutoExec work:

In a regular module in the Normal template, I've got a module named
"AutoExec" and a procedure called Main:

Public Function Main()
MsgBox "autoexec works"
End Function

it didn't work.

I deleted that "AutoExec" module and then in another regular module I
have this code:

Public Function autoexec()
MsgBox "autoexec works"
End Function

it didn't work.

Then i tried a startup switch in the Run menu of Windows :
"C:\Program Files\Microsoft Office\Office10\WINWORD.EXE/mautoexec"

It didn't work. I got an error saying that Windows couldn't find the
path.

Anything else I can try????
Thanks!!!!!!

 

[Ed]

Hi Richard,

When I've done it in the past, I've always named the *macro* AutoExec, not
the module.

This link might be of use:

http://word.mvps.org/FAQs/MacrosVBA/AppClassEvents.htm

One other thing, as far as I know, AutoExec macros don't run when Word is
started by Automation. Probably not relevant to you but worth being aware of.

Regards.

Ed