-->
MSXML can be used when working within applications that support Visual Basic for Applications (VBA), such as Microsoft Office 2003, Microsoft Office 2007 or Microsoft Office 2010.
Microsoft Xml V6.0 For Excel Mac 2011 Basic Formulas
For example, to set a reference to MSXML in a VBA project within Microsoft Word, do the following:
Open Visual Basic Editor in Microsoft Word by editing a Macro.
In the list of available references, select from any of the following versions of MSXML you have installed and wish to reference in your VBA project:
Microsoft XML, v 3.0.
Microsoft XML, v 4.0 (if you have installed MSXML 4.0 separately).
Microsoft XML, v 5.0 (if you have installed Office 2003 - 2007 which provides MSXML 5.0 for Microsoft Office Applications).
Microsoft XML, v 6.0 (on Windows Server 2003 you have to install MSXML 6.0 separately.
Click OK.
Microsoft Xml V6.0 For Excel Mac 2011 Basic Formulas
For example, to set a reference to MSXML in a VBA project within Microsoft Word, do the following:
Open Visual Basic Editor in Microsoft Word by editing a Macro.
In the list of available references, select from any of the following versions of MSXML you have installed and wish to reference in your VBA project:
Microsoft XML, v 3.0.
Microsoft XML, v 4.0 (if you have installed MSXML 4.0 separately).
Microsoft XML, v 5.0 (if you have installed Office 2003 - 2007 which provides MSXML 5.0 for Microsoft Office Applications).
Microsoft XML, v 6.0 (on Windows Server 2003 you have to install MSXML 6.0 separately.
Click OK.
In the Microsoft Office 2011 14.7.7 Update volume window, double-click the Office 2011 14.7.7 Update application to start the update process, and then follow the instructions on the screen. If the installation finishes successfully, you can remove the update installer from your hard disk. Open the Microsoft Office for Mac 2011 14.1 Update volume on your desktop. This step might have been performed for you. To start the update process, in the Microsoft Office for Mac 2011 14.1 Update volume window, double-click the Microsoft Office for Mac 2011 14.1 Update application, and follow the instructions on the screen. I have some VBA code for accessing various XML-based web APIs from Excel (2007, 2010), and have just run up against a user who is on a Mac running Excel 2011. The code I've developed depends on a reference to MS XML 6.0, which apparently isn't available on the Mac. This seems to be a problem others have run up against with no resolution.
Microsoft Xml V6.0 For Excel Mac 2011 Mail Merge
Once this reference is made, you can call and use MSXML application programming interfaces directly from within your VBA project code modules.
