![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Excel Save Topic Summary: Created On: 29-Oct-2007 11:47 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
I am trying to save the excel file using the Automation commands ffice void savefileExcel(string filename) { clear(args) put(args, "FileName", filename) oleMethod(objWorkbook, "SaveAs", args) } In the above script if the excel file already exists It shall prompt me a message A filename already exists do you want to replace it...... When I press Yes it shall replace it as I mentioned the property name as "SaveAs" But If I click No it shall save default as book1 or book2 or so on..... When I click No, Instead of it saving the excel file as book1 or book2 , is there any command which makes me to browse my directory and save the excel sheet at desired location with desired name.
Can any one suggest me a solution... |
|
![]() |
|
![]() |
|
Subrojyoti,
You're working on the DXL side trying to automate Excel. You're not going to be able to bring up a directory browser unless perhaps you write your own VB code to do so. You need to specify things on the DXL side first. You can do a check if a file exists via DXL, and if it does, save it with a different value in your args. If you update args first, you won't have a problem. ------------------------- Kevin Murphy http://www.baselinesinc.com The Requirements Management Experts |
|
![]() |
|
![]() |
|
Hi Kevin, What you said it right. but the present scenario is i am exporting my modules to excel through batch mode as you are aware that batch mode does not allow to popup dialog boxes. |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
Excel Save
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.