Is there an MSXML for MAC EXCEL?

[Kenji]

I'm developing an Excel sheet that uses the MSXML to "POST" data and also
parse XML files.

on the mac version, it seems to not have MSXML.. what's a workaround for
this?

There must be a way to call protocols like "POST" and also a way to parse
XML files for the mac excel.

Thanks in advance!

Kenji

 

[Jim Gordon MVP]

Hi Kenji,

If you use the code in this example:
http://support.microsoft.com/default.aspx?scid=kb;en-us;278976
Excel will not execute the command CreateObject("Microsoft.XMLDOM") because
it uses Active-X, which is proprietary to Microsoft operating systems. Apple
Macintosh does not use Microsoft Active-X.

However, you may be able to accomplish your goal using the POST method
within a web query, which is supported in Excel 98 and later. This article
may be of assistance:
http://support.microsoft.com/default.aspx?scid=kb;[LN];187364

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

 

[Kenji]

Thanks Jim,
This was a huge help.

Kenji

Hi Kenji,

If you use the code in this example:
http://support.microsoft.com/default.aspx?scid=kb;en-us;278976
Excel will not execute the command CreateObject("Microsoft.XMLDOM") because
it uses Active-X, which is proprietary to Microsoft operating systems. Apple
Macintosh does not use Microsoft Active-X.

However, you may be able to accomplish your goal using the POST method
within a web query, which is supported in Excel 98 and later. This article
may be of assistance:
http://support.microsoft.com/default.aspx?scid=kb;[LN];187364

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------

I'm developing an Excel sheet that uses the MSXML to "POST" data and also
parse XML files.

on the mac version, it seems to not have MSXML.. what's a workaround for
this?

There must be a way to call protocols like "POST" and also a way to parse
XML files for the mac excel.

Thanks in advance!

Kenji