read xml on mac

[Lilster]

Hi,
I want to code in my VBA on mac to read XML data to an XLS file. On
PCs, I am able to use the MSXML object, how do I do this on a MAC?
(I am new to VBA and MAC)
Thanks for looking.

 

[Jim Gordon MVP]

Hi,

MSXML is a seperate application that parses XML data into rows &
columns. This application is not available on the Macintosh. You will
need to find a Macintosh application that can accomplish the same thing
or write your own transformation. Perhaps there is one already that will
transform a plain xml document into an XML spreadsheet compliant format,
which Excel 2004 can open and read.

Excel 2004 can open, work with, and save documents in XML spreadsheet
format.

-Jim