Forum Discussion

scdemoor's avatar
scdemoor
Copper Contributor
Nov 11, 2020

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_Hatmaker's avatar
    Craig_Hatmaker
    Copper Contributor

    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 

     

    • scdemoor's avatar
      scdemoor
      Copper 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 Hatmaker's avatar
        Craig Hatmaker
        Iron 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. 

Resources