Autorefreshing excell external data while opening from VBA code

  • Thread starter Thread starter Devendra
  • Start date Start date
D

Devendra

Hi Everybody,

I've created a Excel sheet with a external data link.. Now, I want to
open this excell sheet from VBA code and do some calculation on the
latest data, but, the problem is that the data doesn't gets updated
while I open the sheet from VBA code. [Note: I've selected the option
to update external data as soon as the sheet opens and its working if
I open the sheet normally i.e not from VBA code]

Thanks in advance,
Devendra
 
Back
Top