Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DDE macro execution - aaarrghhh!!!

Status
Not open for further replies.
wadjssd

wadjssd

Technical User
Jan 24, 2002
31
GB
I'm trying to get Access 97 to initiate Word 97 and run a macro within Word.

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 execute MyMacro. Why isn't this working?

channel = DDEInitiate("winword", "SYSTEM")
DDEExecute channel, DoCmd.Maximize
DDEExecute channel, DoCmd.RunMacro("MyMacro")
DDETerminate channel
 
Sort by date Sort by votes
Hi,
Why not have MyMacro in the Document_Open event? :) Skip,
metzgsk@voughtaircraft.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
CTRL + BREAK from second macro button
Replies
5
Views
356
strongm
strongm
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
323
dhookom
dhookom
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
195
mintjulep
M
remeng
  • Locked
  • Question
Multiple Users in a Macro enabled Excel Doc
Replies
0
Views
151
remeng
remeng
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
527
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top