Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autorefreshing excell external data while opening from VBA code
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autorefreshing excell external data while opening from VBA code
Devendra,
Does ThisWorkbook.RefreshAll work? Rob "Devendra" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data Warning Message - I have No External Data in wrkbk | Excel Discussion (Misc queries) | |||
Opening An External File | Excel Discussion (Misc queries) | |||
Getting External Data based on criteria insde of the external data | Excel Discussion (Misc queries) | |||
opening excell | Excel Discussion (Misc queries) | |||
how do I activate links without opening external workbooks? | Excel Discussion (Misc queries) |