Hi Ankur,
In my application I need to save an excel report from a web page.When click on the excel file link , a Pop up window with Open, Savexcel file and Cancel will appear.
Here I have two options to save the file to the local directory
1) Using the Save and give the path, but when give the path through the VBscript and click on the Save button, its not getting saved, The file name passed through VBscript to the filename textbox is not accepting
2) in the second option, after opening I have the below VbScript to save the file , But its not working during run mode,an Error is showing "Object required". Its working when I am Debugging the same step in QTp.
Please help me to get a solution for this issue
In my application I need to save an excel report from a web page.When click on the excel file link , a Pop up window with Open, Savexcel file and Cancel will appear.
Here I have two options to save the file to the local directory
1) Using the Save and give the path, but when give the path through the VBscript and click on the Save button, its not getting saved, The file name passed through VBscript to the filename textbox is not accepting
2) in the second option, after opening I have the below VbScript to save the file , But its not working during run mode,an Error is showing "Object required". Its working when I am Debugging the same step in QTp.
Code:
oExcelApp = GetObject(,"excel.application")
wait(25)
oExcelApp.ActiveWorkBook.SaveAs "C:\xExel.xls"
oExcelApp.Application.QuitPlease help me to get a solution for this issue