I'm trying to write an Excel add-in that can get data from a web service into Excel.
To use it, the user just needs to type a function name provided by the add-in. I found two articles implementing HTTP requests in VBA: XMLHTTP and ServerXMLHTTP.
I have difficulty with using them. I don't know which one to use. What are the differences between XMLHTTP and ServerXMLHTTP?