![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Office OLE Automation Topic Summary: Looking for OLE Automation Reference/Toolkit Created On: 23-Aug-2005 15:08 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Good morning
I'm getting myself involved in some more complex DXL utilities and have the need to interact more closely with MS Excel. I'm wondering if anyone could point to a toolkit and/or reference guide for Excel 2003 OLE Automation. I've checked out Mike Sutherland's "Enhanced Export", but it's only good if I want to "copy" code...I need something that I can educate myself with...something that will be a good read for starting a barebones script. The DXL Help in DOORS get's me only a small amount of this help...(I'm surprised they still provide examples for Excel 95/97)...
Microsoft's Office webpage may be a good start...I just don't know where to "dig" on it.
--John
|
|
![]() |
|
![]() |
|
A good starting point is the Microsoft Excel Object Model and Microsoft Word Object Model for a list of Objects, Methods, Properties, and Events. Even though it falls under Office XP, I was successful in using the reference guide for Office 2000.
You'll use the DXL functions olePut, oleGet, and oleMethod to access the VBA. I discovered a lot by looking at the Word exporter included with DOORS and then trial and error until I got something that worked. You can also open Word/Excel and record a Macro of the task you're trying to automate, then look at the resulting VBA code and try to translate it into DXL calls. -Dennis Edited: 30-Aug-2005 at 21:04 by Dennis Lockshine |
|
![]() |
|
![]() |
|
Mike Sutherland gave a paper on ole automation an a InDoors conference -- the paper is in telelogic archive and also on Galatyic solutions web site. |
|
![]() |
|
![]() |
|
The Object Browser is also useful within the Office Applications to browse Objects, Methods, Properties, and Events.
Edited: 31-Aug-2005 at 10:16 by Ken Mcguffie |
|
![]() |
|
![]() |
|
Edited: 22-Mar-2006 at 14:07 by Audrey Kist |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
Office OLE Automation
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.