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 to Excel Export
Topic Summary:
Created On: 20-Jun-2007 15:25
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.
 20-Jun-2007 15:25
User is offline View Users Profile Print this message


Brian Rohler

Posts: 26
Joined: 20-Jun-2007

Hey, I'm currently creating some custom scripts dealing with exporting DXL modules to Excel and had two questions. Firstly, how do I launch an excel macro from Doors? (I know how to do stuff with Doors from Excel, but not the other way around.) Secondly, is there a way to allow someone in Excel to choose from a multi-choice drop-down list? I've found a way to do a single-choice drop down through Data->Validation->Settings->Allow List. Incase your wondering why I want to do this, I need to export a Doors Module to Excel, then store "enumerations" of each multi-choice and single-choice list so that if the user modifies something in the excel version they can view all the enumerations and don't have to type them in or check the original module for the correct ones. I'd appreciate help on both questions! Thanks!
Report this to a Moderator Report this to a Moderator
 20-Jun-2007 15:34
User is offline View Users Profile Print this message


Brian Rohler

Posts: 26
Joined: 20-Jun-2007

Found a little help on one of my questions for anyone else is interested (Forum Topic Title: dxl excel automation - macro). I Still need help on the excel multi-pick though....
Report this to a Moderator Report this to a Moderator
 20-Jun-2007 15:43
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

Do a search for Macros and you'll find a few threads about calling an Excel macro via DXL.

For the second problem, I don't believe Excel supports multi-valued lists.

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com
Report this to a Moderator Report this to a Moderator
 20-Jun-2007 19:06
User is offline View Users Profile Print this message


Brian Rohler

Posts: 26
Joined: 20-Jun-2007

Is there a way to pass parameters from doors when calling the VB macros in excel? Or for them to access data in Doors and perform actions based on that?
Report this to a Moderator Report this to a Moderator
 21-Jun-2007 12:26
User is offline View Users Profile Print this message


Andrew Tagg

Posts: 151
Joined: 26-Oct-2004

Brian, with Word, you can pass values to 'Custom Document Properties' in the Word document, then get the VBA to pull the values back out from there, I haven't tried this with Excel yet though, but I think the same should work. In Word I use this to store the information I would embed into the header and footer of the document. Otherwise,you could crate a 'redundant' Excel worksheet to store the passed data, them delete it again at the end.

-------------------------
Andrew Tagg
Thales Air Systems, Melbourne
Australia.
andrew.tagg@thalesatm.com
Report this to a Moderator Report this to a Moderator
 21-Jun-2007 13:28
User is offline View Users Profile Print this message


Brian Rohler

Posts: 26
Joined: 20-Jun-2007

That makes sense. Does anyone have an example of this available? (I'm referring to passing values to the Custom Document properties in excel)

Edited: 21-Jun-2007 at 19:18 by Brian Rohler
Report this to a Moderator Report this to a Moderator
 22-Jun-2007 13:54
User is offline View Users Profile Print this message


Andrew Tagg

Posts: 151
Joined: 26-Oct-2004

Brian, the following link refers to doing this in Word, perhaps you could modify it? > https://support.telelogic.com/en/doors/forums/messageview.cfm?catid=17&threadid=4713&enterthread=y

-------------------------
Andrew Tagg
Thales Air Systems, Melbourne
Australia.
andrew.tagg@thalesatm.com
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.