![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Saving Excel file from DXL Topic Summary: Created On: 26-Feb-2004 08:43 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
We make gladly use of the Excel exporter written by Galactic Solutions. When the script stops, we would like to save the Excel file automatically. We are using elements of it to generate history files automatically, which means we want to launch a script and go home. When done, the Excel files need to be saved. Is it possible to run, say, a VB script triggered by DXL to make Excel do this?
Pieter de Waard ------------------------- Pieter de Waard www.nhindustries.com |
|
![]() |
|
![]() |
|
When your Excel script has completed, try this:
// SAVE FILE clear(args); put(args, "FileName", "--- desired filename here ---"); checkRes(oleMethod(objWorkbook, "SaveAs", args)); -=[ Bob Padilla ]=- Ciena Corporation rpadilla@ciena.com |
|
![]() |
|
![]() |
|
Thanks Bob. Do you mean when DXL script finishes, or really Excel script?
Pieter ------------------------- Pieter de Waard www.nhindustries.com |
|
![]() |
|
![]() |
|
Pieter,
Thanks for the kind words about our Enhanced Export to Excel utility. I'll think about building that feature into a future version of the utility. ------------------------- Michael Sutherland michael@galactic-solutions.com http://galactic-solutions.com |
|
![]() |
|
![]() |
|
I've not looked at the Galatic solution, but I will in a few minutes. This would need to be included in the same script when all exporting has completed. It requires the use of the Excel 'objWorkbook' OLE autoobject created in the script to complete the process.
|
|
![]() |
|
![]() |
|
Robert,
I see how these commands below work nicely in the Enhanced Export to Excel of Galatic Solution (I'm going to check on their other dxls). // SAVE FILE clear(args); put(args, "FileName", "--- desired filename here ---"); checkRes(oleMethod(objWorkbook, "SaveAs", args)); But if someone is running a VERY LARGE 4 Level Matrix Report in Batch at night on a dxl, how can someone "CLOSE" the Excel file, and "EXIT" the Excel software leaving just the report in a folder? (I asked DOORS Support this question but couldn't get API advice.) I haven't been able to find the CLOSE and EXIT commands in Microsoft API documents. Thanks, Ben Ben_W_Tooker@raytheon.com ------------------------- Ben Tooker |
|
![]() |
|
![]() |
|
Ben,
Try the following methods (I haven't done so yet): Close and Quit ------------------------- Michael Sutherland michael@galactic-solutions.com http://galactic-solutions.com |
|
![]() |
|
![]() |
|
Michael,
Good point, the "Close' works: checkRes(oleMethod(objWorkbook, "Close", args)); Now at the end, the "Save As" and "Close" works nice, only leaving the Excel software up. I've tried oleMethod with Exits, and Quits (with and without args) along with some connectToApp and disconnectFromApp but can't seem to bring Excel down. Any other possible functions? Respectfully, Ben Ben_W_Tooker@raytheon.com ------------------------- Ben Tooker |
|
![]() |
|
![]() |
|
Ben,
Have you succeeded in solving the problem of getting Excel down? We still have this need, and it will be nice to know how it can be done. Thanks, Pieter ------------------------- Pieter de Waard www.nhindustries.com Edited: 21-Feb-2005 at 15:03 by Pieter DE WAARD |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
Saving Excel file from DXL
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.