![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
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 |
![]() |
![]()
|
![]() |
|
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 ##################### |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 ###### |
|
![]() |
|
![]() |
|
Check ole automation in this forum and in the dxl help file
|
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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. |
|
![]() |
Telelogic DOORS
» General Discussion
»
Excel Link to DOORS
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.