Technology

Arrrgh Microsoft Office VBA & XML!

I was doing some playing around with Microsoft Office today and actually created a form that would post to an API and then bring back the response XML. Since Office 2003 is XML integrated, I then looked to see how I could easily parse the returned XML to save it to a table or temporary recordset….

Aarrrrgh!

This is when I find out that Microsof Office 2003 is fully integrated with XML (or MSXML) through it’s GUI (Graphical User Interface) but NOT through the VBA (Visual Basic for Applications) engine. That means that, though I can get the XML response, I have to use code to parse the XML and work with it.

My guess is that the problem is that VBA really hasn’t changed since Visual Basic 6.

NOTE TO MICROSOFT: Update your Programming Interface when you release featurers in your Graphical User Interface! Geeez.

Download a Sponsored Marketing Whitepaper:
2018 State of B2B Marketing Technology

2018 State of B2B Marketing Technology

Growing Emphasis & Investment On Personnel To Manage TCO & ROI From Expanding Tech Stacks. Download Now

This site uses Akismet to reduce spam. Learn how your comment data is processed.