I have a spreadsheet which is being used as a logsheet in a manufacturing facilty. I have a webserver running a PosgreSQL database and PHP and a decent web site running with pages allowing entry of this data into the database through a form. I also have a method where I can cut the data from excel, paste it into a <textarea> block and add this tab-delimited data. Despite these two options, what I would really like to be able to do is to press a button on the Excel spreadsheet itself and have it form the HTTP post request and submit it to the webserver. I don't need to use the response to do anything with the excel spreadsheet, I just need to submit the data.
I've seen a few pages online referencing a HTTPRequest object within VBA. However, when I use the object browser in my Excel 2010 application, I don't see this object available on the list.
I'm not a VBA expert by any means, but I've done my share of programming. I should be able to hobble together parts to parse the text from the cells, concatinate it into a string and all that. I just need help with the socket formation and manipulation.
Thanks,
Kevin
I've seen a few pages online referencing a HTTPRequest object within VBA. However, when I use the object browser in my Excel 2010 application, I don't see this object available on the list.
I'm not a VBA expert by any means, but I've done my share of programming. I should be able to hobble together parts to parse the text from the cells, concatinate it into a string and all that. I just need help with the socket formation and manipulation.
Thanks,
Kevin
