![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
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 |
![]() |
![]()
|
![]() Answer: | |
![]() |
|
|
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
|
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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.
|
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
|
|
![]() |
|
![]() |
|
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 |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
dxl excel automation - macro
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.