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: dxl excel automation - macro
Topic Summary: how do i run an excel macro with automation ?
Created On: 20-Mar-2006 14:29
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.
Answer This question was answered by Audrey Kist, on Tuesday, March 21, 2006 8:56 AM

Answer:
 20-Mar-2006 14:29
User is offline View Users Profile Print this message


Audrey Kist

Posts: 4
Joined: 20-Mar-2006

Report this to a Moderator Report this to a Moderator
 20-Mar-2006 15:42
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

Sounds like you already know how to connect to Excel and open your file.

To run a macro, you need to know the name of the macro, then do something like the following.
Note that I have not tried this. This is based on Word which is probably similar??


clear(autoArgs)
put(autoArgs, "Macro-name")
oleMethod(excelApplication, "Run", autoArgs)

where excelApplication is the object you created using:

excelApplication = oleCreateAutoObject("Excel.Application")

Hope this helps.

-------------------------
Tony Goodman
http://www.smartdxl.com
Report this to a Moderator Report this to a Moderator
 21-Mar-2006 08:56
User is offline View Users Profile Print this message


Audrey Kist

Posts: 4
Joined: 20-Mar-2006

Answer Answer
Report this to a Moderator Report this to a Moderator
 21-Mar-2006 18:00
User is offline View Users Profile Print this message


Michael Sutherland

Posts: 248
Joined: 13-Sep-2002

Tony,

Thanks for answering the question.

All,

Has anyone developed functionality to call Microsoft Visio macros from DOORS?

-------------------------
Michael Sutherland
michael@galactic-solutions.com
http://galactic-solutions.com
Report this to a Moderator Report this to a Moderator
 23-Mar-2006 16:40
User is offline View Users Profile Print this message


Kevin Murphy

Posts: 206
Joined: 15-Jul-2005

Michael,

Create a Visio file with a macro in it. For this example, I used Macro1 as the name of the macro I wanted to call.

This has only been tested with Visio 2003.

-------------------------
Kevin Murphy
http://www.baselinesinc.com
The Requirements Management Experts

Edited: 23-Mar-2006 at 21:20 by Kevin Murphy
Report this to a Moderator Report this to a Moderator
 30-Mar-2006 17:19
User is offline View Users Profile Print this message


JOSE KOENIG

Posts: 1
Joined: 30-Mar-2006

I am completely new to DOORS. This topic caught my attention because that is exactly what I am trying to do; however, I don't know even know how to connect to Excel and Open the file. If you could please tell me how to do this, then I just follow the rest of the threads. Thanks in advance.
Report this to a Moderator Report this to a Moderator
 30-Mar-2006 20:28
User is offline View Users Profile Print this message


Michael Sutherland

Posts: 248
Joined: 13-Sep-2002

Jose,

I have a presentation here that might help. I also have the "Enhanced Export to Excel" source code example available here.

-------------------------
Michael Sutherland
michael@galactic-solutions.com
http://galactic-solutions.com

Edited: 30-Mar-2006 at 20:31 by Michael Sutherland
Report this to a Moderator Report this to a Moderator
 31-Mar-2006 09:02
User is offline View Users Profile Print this message


Audrey Kist

Posts: 4
Joined: 20-Mar-2006

Report this to a Moderator Report this to a Moderator
 4-Apr-2006 18:50
User is offline View Users Profile Print this message


Michael Sutherland

Posts: 248
Joined: 13-Sep-2002

Kevin,

I was able to get the "Execute Line" method to work with Visio 2002. Thanks!

-------------------------
Michael Sutherland
michael@galactic-solutions.com
http://galactic-solutions.com
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.