Macro or VBA to open & select menu items

[linuxlost]

I have a macro in access that exports (opens a) RTF document in MS Word.
Then I have to manually (mouse) enter: tools, Macro, macros, then I must
select one of two files (these are converted to VBA from the macro-recorder)
1-weekend or 2-holiday, then I click run. Then the macro takes over
adding columns, text and automatically printing.

Is it possible to have the tools menu and subsequents selections happen
automatically? I would prefer to do this as an extension of a macro from MS
access but a toggle or hotkey would also be a solution.

 

[Jezebel]

Why not just call the macros directly?

 

[Cindy M.]

Hi =?Utf-8?B?bGludXhsb3N0?=,

I have a macro in access that exports (opens a) RTF document in MS Word.
Then I have to manually (mouse) enter: tools, Macro, macros, then I must
select one of two files (these are converted to VBA from the macro-recorder)
1-weekend or 2-holiday, then I click run. Then the macro takes over
adding columns, text and automatically printing.

Is it possible to have the tools menu and subsequents selections happen
automatically? I would prefer to do this as an extension of a macro from MS
access but a toggle or hotkey would also be a solution.

Take a look at the Application.Run method in Word.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[linuxlost]

How do I call a macro directly? or how do I call vba script directly?

 

[Jezebel]

[WordApplication].Run "MyMacro"

How do I call a macro directly? or how do I call vba script directly?