Hi
I used ExternalData("C:\book1","Global") and also the above syntax. it works fine
however one problem
When I tried to save an excel file and the file is already exists at the location. Then an alert comes "File is already exists, Do you want to replace it?" with button "Yes | No | Cancel". Then I am to choosing option manually, I can close that pop up using QTP.
but is there any method to clear all the excel cells, so that Excel Pop-up to save does not come at all.
I used ExternalData("C:\book1","Global") and also the above syntax. it works fine
however one problem
When I tried to save an excel file and the file is already exists at the location. Then an alert comes "File is already exists, Do you want to replace it?" with button "Yes | No | Cancel". Then I am to choosing option manually, I can close that pop up using QTP.
but is there any method to clear all the excel cells, so that Excel Pop-up to save does not come at all.