Is There Is any way to Acess the Excel Sheet when Data dynamically changes Every Day

Hi,

Thanks Again Marsha Robertson

Eeven i tried in that way also but the fuctions i want  with date ,time and week number are complex in the smart bear they are not fecthing in the way(format) i want to validate through the check points .So its made or make simple for me if they fectches from sheet

thats way presently i am opening the sheet before  running Test Case(through script only)

like

function test()

{

//code



     var fileName = "..//path.xlsx";

     var sheetName = "Sheet1";

     var app = Sys.OleObject("Excel.Application")

     Options.Run.Timeout = 30000;

     var book = app.Workbooks.Open(fileName);

     var sheet = book.Sheets(sheetName);

     book.Save();



//code

    app.Quit();

}



some times this raising popup like do u want save the changes in the excel

in that case my test case in failing/reporting an error

if we have any solution its better



for thar i am going use event handler..(learing)



Thanks in advance..