Oh, That's Not Good...
Mar. 28th, 2006 06:17 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
billroperI'm trying to get an Excel add-in that our company wrote to reach out to our web server and retrieve data from it and display it in Excel. Unfortunately, the documentation on the add-in is perhaps less helpful than I might hope. The only thing that's making it possible at all is that I'm porting over code that was written for another of our products, so I've got a leg up.
I'm sniffing the XML using TCPTrace and fixing up calls as I go. I've managed to get a connection established to our web server. So far, so good.
But now, I select an item off the Excel menu that might actually try to retrieve some data. The web server answers two requests with what looks like reasonable XML, and the add-in tells me that I don't have a valid connection.
Crud. Now I need to talk to one of the writers of the add-in to find out what the black box is up to.
I'm sniffing the XML using TCPTrace and fixing up calls as I go. I've managed to get a connection established to our web server. So far, so good.
But now, I select an item off the Excel menu that might actually try to retrieve some data. The web server answers two requests with what looks like reasonable XML, and the add-in tells me that I don't have a valid connection.
Crud. Now I need to talk to one of the writers of the add-in to find out what the black box is up to.