Closing Excelsheet using VBScript
In my AUT, there is functionality to export the HTML report in to excel. On clicking the 'download' button, application displays "File Download" windows diaload box.
On clicking button 'Open', the report is displayed as excel sheet.
This happens in a loop for multiple reports. I want to close excel sheet after oepning it each time.
How can I do that? I probably can not use Quit() method in this case.
Thanks in advance.
Re: Closing Excelsheet using VBScript
Is the sheet opened inside the browser or in excel only?
If excel then you can use the below code
if NOT xlApp is nothing then