Forum Discussion

srinivas_yadati's avatar
srinivas_yadati
Occasional Contributor
11 years ago
Solved

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

Hi  I want help for accessing the data from external sources when data of the excel sheet chages everyday. for ex: i am using Today() function in excel sheet the cvariable i created throu...
  • Colin_McCrae's avatar
    Colin_McCrae
    11 years ago
    If you're using Excel as a COM object you can disable the notifications popups ....



    app.DisplayAlerts = False



    Should do it in your case.
srinivas_yadati's avatar
srinivas_yadati
Occasional Contributor
11 years ago
Thanks Marsha Robertson

I Verified this solution earlier its meeting code metric standards and not effective i feel 

but



I agreed with the solution provided by the Colin McCrae ,its working fine 



Once again Thanks for the Support Marsha Robertson Colin McCrae