Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: Invoke MS-Word Macro
Topic Summary:
Created On: 15-Jan-2009 15:50
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 15-Jan-2009 15:50
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

How can I command MS-Word to execute a Macro if its been added?

So far my numerous report scripts generate the output, create a temp file and set its contents (and close it), then invoke MS-Word to display the file. That is, I don't send OLE commands to Word.

After the file is displayed the user is expected to format it appropriately, which means skip the first few preamble lines, select the bulk of the file that is supposed to become an MS-Word table, make the table and do lots of formatting. I've created MS-Word macros that do those chores, and finally created a master macro that figures out exactly what to do (e.g. column 4 width) based on the name of the displayed file, which always starts with the name of the script.

One time per User per client machine, Users are expected to seek out the Word template (on the network), connect to it, so the Macros and the Toolbar Icon are always available to them.

I'm pretty sure I need to be told how to do these things:

[1] find the instance of MS-Word currently running on the client that is displaying a specifically named file. That is, find the MS-Word displaying 'MyDXL' and ignore the one displaying 'MyTimeCard'.

[2] Command that instance of MS-Word to look for a particularly named Macro. If that macro exists then command that instance of MS-Word to run it.

- Louie
Report this to a Moderator Report this to a Moderator
 15-Jan-2009 16:15
User is offline View Users Profile Print this message


ron lewis

Posts: 650
Joined: 20-Sep-2004

Louie, part of your solution can be found here:
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.