Who Runs Pretty Thin Web Site?

Dynamic HTML - Assign value of excel cell to a jscript variable in a web page.

• Requirement: To build a live data feed that runs continuously, at a configurable interval and passes a value I need: from a fixed location on a particular web page to a javascript assignment statement in a js file on my web site. I have already created an excel web query that retrieves the data item I need from that web page and places it in a fixed location in my excel spreadsheet. Phase 1. Now I need to use that value in my excel cell, such as 7.51 as the right operand in a javascript assignment statement, such that the result is a javascript assignment statement that reads vname = 7.51 . This is a dynamic html application and needs to happen at run time. Phase 2. Next, I need to automate the process so it runs at a configurable interval continuously. I do have an always connected (broadband) connection. Experts only, please. jim

• Answer:

  I have enjoyed the challenge of working on this question. If you have similar scripting problems in future that you'd like me to help with, you can mention my name in the subject line so that I'll find the question easily. leapinglizard