QTP_Save CSV file during Runtime

[Yamini]

Hi,

I really appreciate and its great team work to bring this forum for all who is behind this hub.For me QTP is still exploratory and I have so much to learn and this being good source to learn and exchange knowledge.

This would be my first query in here that Iam trying to figure out :

In my QTP script,I have a runtime HTML window which opens a CSV file.I need to save this CSV file to local drive as "Xls" file and verify data.

I tried to use following code but not sure if Iam doing right thing :

Code:

Set xlsObj = Window("").WinObject("")
xlsObj = activeworksheet.SaveAs("localDrivePath\ab.xls")

or

Code:

Window("").WinObject("").Type (micCtrlDwn + "F12" + micCtrlUp)

or

Code:

Browser("").WinToolbar("").ShowDropdown("&File")

Iam stuck at next time how to make QTP understand select "SAve As" and provide localpath to save file.

Please help me if somebody have ideas on this issue.

Thanks
Yamini

[surya_7mar]

Dont go to a scenerio where you save the XLS after opening.

Browser defnitely ask you whether to save or open before opening a XLS file

So click Save button there and use the Save As Dialog Box to save the file to specific locaiton in the System