Interactive website running on Excel.

%3CLINGO-SUB%20id%3D%22lingo-sub-1877924%22%20slang%3D%22en-US%22%3EInteractive%20website%20running%20on%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1877924%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20someone%20please%20point%20me%20in%20the%20right%20direction%20to%20get%20started%20with%20the%20following%3A%3CBR%20%2F%3EI'm%20trying%20to%20find%20a%20way%20to%20pass%20data%20received%20from%20a%20website%20(say%2C%20a%20form)%20to%20Excel%2C%20then%20send%20the%20processed%20values%20back%20to%20the%20same%20website.%20I%20can%20of%20course%20sign%20up%20with%20a%20commercial%20company%20and%20have%20this%20done%20at%20great%20cost%2C%20but%20it%20would%20be%20more%20fun%20to%20create%20my%20own%20solution!%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EMany%20thanks%20for%20your%20time%20and%20input.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1877924%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1884307%22%20slang%3D%22en-US%22%3ERe%3A%20Interactive%20website%20running%20on%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1884307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765579%22%20target%3D%22_blank%22%3E%40scdemoor%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20you%20are%20asking%20for%20is%20not%20trivial%20and%2C%20depending%20on%20the%20website's%20design%2C%20may%20not%20be%20possible.%20Assuming%20the%20website%20allows%20posts%2C%20this%20library%20is%20what%20I%20use.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsites.google.com%2Fsite%2Fbeyondexcel%2Fproject-updates%2Fwebscraper%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsites.google.com%2Fsite%2Fbeyondexcel%2Fproject-updates%2Fwebscraper%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1887417%22%20slang%3D%22en-US%22%3ERe%3A%20Interactive%20website%20running%20on%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1887417%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F773415%22%20target%3D%22_blank%22%3E%40Craig_Hatmaker%3C%2FA%3E%26nbsp%3BThanks.%20Not%20the%20answer%20I%20was%20hoping%20for%20unfortunately%2C%20and%20the%20click%20bait%20didn't%20work.%20I%20have%20control%20over%20both%20the%20website%20and%20the%20spreadsheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1887490%22%20slang%3D%22en-US%22%3ERe%3A%20Interactive%20website%20running%20on%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1887490%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765579%22%20target%3D%22_blank%22%3E%40scdemoor%3C%2FA%3E%26nbsp%3BClick%20bait%3F%3CBR%20%2F%3EI%20give%20it%20freely%20to%20those%20who%20ask.%20It%20is%20a%20tried%20and%20true%20library%20of%20web%20manipulation%20routines%20with%20instructions%20and%20examples.%20It%20is%20the%20only%20library%20that%20I%20don't%20just%20provide%20a%20link%20to%20because%20of%20its%20potential%20for%20abuse.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@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 

 

Highlighted

@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.

Highlighted

@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.