Forum Discussion
Interactive website running on Excel.
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
- Craig_HatmakerCopper Contributor
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
- scdemoorCopper Contributor
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.
- Craig HatmakerIron Contributor
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.