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!
Refresh XML Data programmatically.
Hot Topic
- Extending the class designer
- Cecil project from Mono : better than Linq ?
- forget my admin password
- Quick Question
- Designer not showing up
- Outlook Schedules, Meetings and Tasks
- ObjectDataSource using SSRS in ASP.NET 2.0
- Debugging of managed programs across the Internet?
- ASPNETCompiler Error - System.Web.AspNetHostingPermission, System
- Error : Value cannot be null ,Parameter name:Key
Visual Studio
- Reliable Sessions - The Image Transfer Demonstration
- Hosting WCF Router in IIS
- Error "CallbackOnCollectedDelegate was detected" found in VS2005(final)
- Automation API and WPF
- VS 2005/VSS 2005 - Error while checking (HTTP)
- Macro Help
- its no longer possible to use a 'different' build configuration
- EnvDTE80.TextDocumentKeyPressEvents.BeforeKeyPress functionality
- VS 2003 install - says I need to reboot when I do not!
- MSMQ over HTTP
Refresh XML Data programmatically.
Ashwin Raja
It is actually very easy to find out how UI commands correspond to Object Model calls by using Macro Recording. I just went to Tools->Macros->Record New Macro and then clicked on "Refresh XML data" then pressed ALT+F11 to open VBE, navigate to Module1 and checked out the macro that was recorded for me:
The result was ActiveWorkbook.XmlMaps("moo_Map").DataBinding.Refresh
And that is the answer to the original question.