DDE link to run a Word97 macro from Access97

[wadjssd]

This is probably really simple, but I am new to DDE coding....

I want to get a macro in Word to run when I click a button in Access. I can get Word initiated, but cannot get the code to work right so that the macro runs too.

Any help much appreciated.

Thanks.

 

[gcole]

I believe the DoCmd in VBA will run a Macro.

 

[wadjssd]

Okay, I've got the DoCmd object, and am trying to get both the Maximize and RunMacro functions to work, ie to maximize my Word application and run execute MyMacro. Why isn't this working? Thanks again!

channel = DDEInitiate("winword", "SYSTEM&quot
DDEExecute channel, DoCmd.Maximize
DDEExecute channel, DoCmd.RunMacro("MyMacro&quot
DDETerminate channel