Various VBA tasks

[John Davidson]

Folks,

1) Is there a way to Cause a VBA event handler to be regestered by
the openning of the Word Application. Sort of an auto exec
for
VBA .

2) When I coded the application I located the code and forms in a
document other then Normal.dot is there a way to automagically
merge them in to a users Normal.dot?

Thanks In Advance,

{John}


I really miss programing in Cusp or even Mesa.

 

[Jonathan West]

Folks,

1) Is there a way to Cause a VBA event handler to be regestered by
the openning of the Word Application. Sort of an auto exec
for
VBA .

How to create global event procedures similar to AutoOpen,
AutoNew and AutoClose, without using Normal.dot
http://word.mvps.org/FAQs/MacrosVBA/PseudoAutoMacros.htm

2) When I coded the application I located the code and forms in a
document other then Normal.dot is there a way to automagically
merge them in to a users Normal.dot?

Don't even try.

Distributing macros to other users
http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm

 

[Jezebel]

Folks,

1) Is there a way to Cause a VBA event handler to be regestered by
the openning of the Word Application. Sort of an auto exec
for
VBA .

Yes. Write a sub called AutoExec or a sub called Main in a module called
AutoExec.

2) When I coded the application I located the code and forms in a
document other then Normal.dot is there a way to automagically
merge them in to a users Normal.dot?

Technically possible, but difficult and also considered bad practice. (The
user's Normal.dot is sacrosanct.) If you're wondering how to distribute
your VBA application, read up on templates and add-ins.