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: Excel Link to DOORS
Topic Summary: Searching for functionality following an Excel Link to an DOORS Object
Created On: 10-Apr-2006 10: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.
 10-Apr-2006 10:25
User is offline View Users Profile Print this message


Frank Gonzalez-Morphy

Posts: 3
Joined: 7-Feb-2006

Hi Guys and Profis,

I'm seraching for a functionality, maybe a Excel Add-In or a VBA Macro, to be able to jump from
a Link beeing in a Excel-Sheet to a dedicated DOORS Object following the Path and Object-ID
to opening in DOORS the corresponding Module and highlightning the selected Object-ID.
Of course DOORS must be opened before this functionality will be used for the first time.

I didn't found anything out there in the Internet. I hope this is not to tricky and complicated
to do, if it isn't already somewhere existent.
I can't imagine that nobody in past didn't ask before for this functionality, or I'm wrong?

Such as a functionlity is already implemented on the Import Add-In for Word "doors.dot" which
is coming with the DOORS installation ($DOORS-Installdir$\Telelogic\DOORS 7\lib\word ).
Unlikely the Add-In is password protected.

Thanks for any quick help, hint or Feedback on this!

Regards,
Frank
Engineering Consulting @ BMW, Germany
frank.gonzalez-morphy@bmw.de
#####################
Report this to a Moderator Report this to a Moderator
 10-Apr-2006 12:25
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

Navigating to a DOORS object is pretty straight forward as long as you know the module name or uniqueID and the absolute number of the object. This can be implemented easily using the DOORS COM API.

The trouble is that these identifiers are presumably editable by the user, so your script will need loads of error checking. You also have the problem of how to populate cells in Excel with the uniqueID's in the first place.

The DOORS.DOT template file does not contain any functionality like this, and the macros ARE password protected.

-------------------------
Tony Goodman
http://www.smartdxl.com

Edited: 10-Apr-2006 at 12:31 by Tony Goodman
Report this to a Moderator Report this to a Moderator
 10-Apr-2006 17:17
User is offline View Users Profile Print this message


Frank Gonzalez-Morphy

Posts: 3
Joined: 7-Feb-2006

Hi Tony,

thanks a lot for you shorty and directly answers.

I didn't till yet programmed a Macro using the DOORS COM API. I supposed I must write VBA-Code to get to my goal. That's why I also tryed to take a look into the "doors.dot" File.
Do you have an short file who I can use as example and make my first try? Or where do you think I could find such a beginning?

It sounds great that it is a straight forward thing.
Yes I know the Module Name as well the unique Object-ID.

The trouble shouldn't happen because I'm the only who is able to modify the Object-ID's iin DOORS.

Thank everybody could help me further.

Regards,
Frank
######
Report this to a Moderator Report this to a Moderator
 10-Apr-2006 18:01
User is offline View Users Profile Print this message


ron lewis

Posts: 650
Joined: 20-Sep-2004

Check ole automation in this forum and in the dxl help file
Report this to a Moderator Report this to a Moderator
 11-Apr-2006 13:02
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

Here is a simple "Hello World" Excel Macro that starts doors and runs a command.

Notice that the quotes in the command string are escaped by doubling them up.

I suggest that you make most of the functionality available via functions in DOORS and keep the interface between Excel and DOORS as simple as possible.

Hope this gets you started.

-------------------------
Tony Goodman
http://www.smartdxl.com
Report this to a Moderator Report this to a Moderator
 11-Apr-2006 14:12
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

Frank, here is a slightly more useful example.
The following is the macro and the code for the include file is in the next post.

-------------------------
Tony Goodman
http://www.smartdxl.com

Edited: 11-Apr-2006 at 14:54 by Tony Goodman
Report this to a Moderator Report this to a Moderator
 11-Apr-2006 14:14
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

Here is the code for the file mentioned in previous post.

-------------------------
Tony Goodman
http://www.smartdxl.com

Edited: 11-Apr-2006 at 14:14 by Tony Goodman
Report this to a Moderator Report this to a Moderator
 12-Apr-2006 14:04
User is offline View Users Profile Print this message


Frank Gonzalez-Morphy

Posts: 3
Joined: 7-Feb-2006

Dear Tony,

whou, respect respect, you know exactly what I search for and how to do it.
The Code is exactly what I search for. I will implement it in the next days, maybe thorugh
eastern and post my results to this issue on the forum, so everybody could make use
of it.

Kindly regards for your great help!!!

------------------------------
Frank Gonzalez-M.
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.