open word then run vba automation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

linuxlost - 19 Sep 2006 12:59 GMT

I have a macro in access that exports (opens a) RTF document in Word.

Then I have to manually (mouse) enter: tools, Macro, macros, then I must
select one of two files: 1-weekend or 2-holiday, then I click run. Then the
macro (VBA) takes over adding columns, text and automatically printing.

I want to have the macro in access open the previosly described series to
run the word macro. How do I do this?

Reply to this Message

Kevin Jameson - 19 Sep 2006 15:06 GMT

you cant do this with microsoft access 2003

you must upgrade to access 20004 by clicking here:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html

HTH

Kevin

>I have a macro in access that exports (opens a) RTF document in Word.
>
[quoted text clipped - 5 lines]
> I want to have the macro in access open the previosly described series to
> run the word macro. How do I do this?

Reply to this Message