Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I don't have Excel 2005, so I can't answer directly.
But did you try recording a macro while clicking that function? HTH -- AP "terrence_chan99" <terrence_chan99.261eam_1144653005.2383@excelfor um-nospam.com a écrit dans le message de news:terrence_chan99.261eam_1144653005.2383@excelf orum-nospam.com... In Excel 2005 menu, there is a function called "Refresh XML Data" under menu Data/XML/. I wonder how can I call this programmatically, so that when the worksheet is opened it will refresh the data automatically. Thanks! -- terrence_chan99 ------------------------------------------------------------------------ terrence_chan99's Profile: http://www.excelforum.com/member.php...o&userid=33319 View this thread: http://www.excelforum.com/showthread...hreadid=531430 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
Programmatically creating a map from data in Excel | Excel Programming | |||
How to associate data with schemas programmatically using .NET | Excel Programming | |||
programmatically refreshing data | Excel Programming | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming |