Refresh XML Data programmatically.

[terrence_chan99]

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!

 

[Ardus Petus]

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"
<[email protected]> a écrit dans
le message de
news:[email protected]...