Interactive website running on Excel.

Copper Contributor

Dear All,

 

Could someone please point me in the right direction to get started with the following:
I'm trying to find a way to pass data received from a website (say, a form) to Excel, then send the processed values back to the same website. I can of course sign up with a commercial company and have this done at great cost, but it would be more fun to create my own solution!

Many thanks for your time and input.

3 Replies

@scdemoor 

What you are asking for is not trivial and, depending on the website's design, may not be possible. Assuming the website allows posts, this library is what I use. 

https://sites.google.com/site/beyondexcel/project-updates/webscraper 

 

@Craig_Hatmaker Thanks. Not the answer I was hoping for unfortunately, and the click bait didn't work. I have control over both the website and the spreadsheet.

@scdemoor Click bait?
I give it freely to those who ask. It is a tried and true library of web manipulation routines with instructions and examples. It is the only library that I don't just provide a link to because of its potential for abuse.