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