Cross platform VBA help required. I need to be able to connect to a remote server from VBA in Mac Ex

[Chris Houston]

Hi,

Using VBA on a PC I can use XMLHTTP or ServerXMLHTTP to connect to a remote
server to post some data,
ideally I would like to enable my Excel Addin to work on both a PC and a
MAC, so, my problem is how can I post
data to a server using MAC VBA ?

Best regards,

Chris

 

[Jim Gordon MVP]

Does the following from Mac Excel help answer the question?

Post Method
See Also Example Applies To
Posts the specified workbook to a public folder. This method works only
with a Microsoft Exchange client connected to a Microsoft Exchange server.
Syntax
expression.Post(DestName)
expression Required. An expression that returns a Workbook object.
DestName Optional Variant. This argument is ignored. The Post method
prompts the user to specify the destination for the workbook.

The help also suggests investigating using the Post method with a a web
query, which is also supported.

-Jim