Web page input to Excel

[djl0525]

I need to take a online survey (intranet) and I want the users input (text and values) to be automatically stored in Excel. Sort of like an Access Web Page. Is this possible? Hmmmm...

DJ

 

[Tazguy37]

As far as I know (I've never done this myself, but it's late, and you might want something to play around with and figure it out some on your own first) you need to use a web query to do that. Lookup "Create a Web query" in the Excel help, and see if that gets you started.

Hope that helps!

 

[djl0525]

Unless I am missing something, I don't think a web query will do it. With a web query you ask Excel to go to a web page and bring back the data that is stored in that page. My data is not going to be stored in a web page. It will be entered into a web page which will merely act as a form, but I need it to be stored in Excel. I kind of need to go in the opposite direction of a web query. Any other thoughts?

DeLisa