Nov 11 2020 11:47 AM
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.
Nov 13 2020 05:00 AM
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
Nov 14 2020 11:22 AM
@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.
Nov 14 2020 12:46 PM
@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.