![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: control doors via excel Topic Summary: how can i start doors with different parameters from excel? Created On: 5-Jun-2007 14:16 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Hi,
I am currently developing a tool that starts doors from excel and performs different tasks (like exports). but i want to start doors with different parameters, e.g. another db or addins.
currently i'm using these lines:
Dim DOORSObj As Object
Set DOORSObj = CreateObject("DOORS.Application")
how can i give doors parameters in that context?
Thanks, cheers
Andreas
|
|
![]() |
|
![]() |
|
Looking at the CreateObject help on MSDN, it doesn't look like you can include parameters to pass to the object you're creating.
If you want to run scripts though, use: DOORSObj.runFile(dxlFileName) Be sure your filename includes the path to it. ------------------------- David Pechacek AAI Services Textron dpechacek@sc-aaicorp.com David.Pechacek@gmail.com |
|
![]() |
|
![]() |
|
Hi Andreas,
AFAIK the Doors.Application OLE object will conect to first existing Doors session or will start a default session. So if it is possible in your application, you could start doors with the needed parameters before connecting to it. Another option is to modify registry to set parameters of default session. Refer to "Settings in the registry " section in Doors manual. Hope that helps you, Greetings Reik ------------------------- Evosoft GmbH for Siemens Industry Sector Berlin, Germany |
|
![]() |
|
![]() |
|
Building on Reik's idea, if its possible in VB to do it, you could change the registry values to suit your needs in the VB script before launching DOORs. Of course you'll also need permissions to do this on your machine. Just be sure to store and restore the old values when done.
------------------------- David Pechacek AAI Services Textron dpechacek@sc-aaicorp.com David.Pechacek@gmail.com |
|
![]() |
|
![]() |
|
For that matter, you could do a system call and use the command line parameters (listed in the manual) to set the options. Then connect to it using OLE/COM.
Chris |
|
![]() |
|
![]() |
|
Hi,
Its a bit rough but you can set the Doors Result property in VB with your parameter then 'extract in using the oleGetResult() in DXL.
i.e.
in VBA:-
Dim modName As String
Dim resultStr As String
Set Doors = CreateObject("DOORS.Application")
Doors.Result = "parameter"
Doors.runStr ("#include ""H:/Auto/wordAutomation.inc""")
in DXl
string param = oleGetResult()
|
|
![]() |
|
![]() |
|
Hi,
For some reason the CR's were stripped out... Its a bit rough but you can set the Doors Result property in VB with your parameter then 'extract in using the oleGetResult() in DXL. i.e. in VBA:- Dim modName As String Dim resultStr As String Set Doors = CreateObject("DOORS.Application") Doors.Result = "parameter" Doors.runStr ("#include ""H:/Auto/wordAutomation.inc""") to get the parameter in DXL :- string param = oleGetResult() Edited: 12-Jun-2007 at 16:16 by David McMahon |
|
![]() |
|
![]() |
|
He meant parameters like choosing a database to connect to. Once DOORS is running, you can't change that.
------------------------- David Pechacek AAI Services Textron dpechacek@sc-aaicorp.com David.Pechacek@gmail.com Edited: 18-Jun-2007 at 20:00 by David Pechacek |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
control doors via excel
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.