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 Save
Topic Summary:
Created On: 29-Oct-2007 11:47
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.
 29-Oct-2007 11:47
User is offline View Users Profile Print this message


Subrojyoti Sengupta

Posts: 52
Joined: 18-Nov-2005

I am trying to save the excel file using the Automation commands

fficeffice" />> >

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...

Report this to a Moderator Report this to a Moderator
 29-Oct-2007 13:04
User is offline View Users Profile Print this message


Kevin Murphy

Posts: 206
Joined: 15-Jul-2005

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
Report this to a Moderator Report this to a Moderator
 30-Oct-2007 08:05
User is offline View Users Profile Print this message


Subrojyoti Sengupta

Posts: 52
Joined: 18-Nov-2005

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. 

what exactly i am doing is ,  i am running a batch process which opens doors and exports modules to excel while exporting if the excel file does exist it shall prompts us a message file exist would you like to replace if i click yes it shall replace but if i press No it should ask me to save at some location with some name....

i think you might get to know what i need it .....

 can you suggest me a solution like if user clicks No  a browser window to come to save the excel file

Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 2 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 2 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.