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: 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
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.
 5-Jun-2007 14:16
User is offline View Users Profile Print this message


Andreas Schleicher

Posts: 3
Joined: 28-Apr-2005

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
Report this to a Moderator Report this to a Moderator
 5-Jun-2007 17:49
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

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
Report this to a Moderator Report this to a Moderator
 5-Jun-2007 19:29
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

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
Report this to a Moderator Report this to a Moderator
 5-Jun-2007 21:28
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

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
Report this to a Moderator Report this to a Moderator
 8-Jun-2007 16:34
User is offline View Users Profile Print this message


Chris Jones

Posts: 177
Joined: 1-Jul-2005

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
Report this to a Moderator Report this to a Moderator
 12-Jun-2007 16:09
User is offline View Users Profile Print this message


David McMahon

Posts: 16
Joined: 15-Apr-2005

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()
Report this to a Moderator Report this to a Moderator
 12-Jun-2007 16:15
User is offline View Users Profile Print this message


David McMahon

Posts: 16
Joined: 15-Apr-2005

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
Report this to a Moderator Report this to a Moderator
 18-Jun-2007 19:59
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

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
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 2 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 2 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.