View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
TonyH.[_2_] TonyH.[_2_] is offline
external usenet poster
 
Posts: 1
Default javascript causing web query problems

Sounds like life is going to start sucking on this end of the keyboard.
Timbo, thanks for the answer

T.



"Tim Williams" wrote:

Your best bet may be to automate IE and have it open the offending page.
Any javascript will run and produce the desired output: you can then get at
the data via the Document Object model.

Try searching the Google group archives for "automate IE Excel": there have
been a few relevant threads recently.

--
Tim Williams
Palo Alto, CA


"TonyH." wrote in message
...
I'm having a problem pulling in data from a site that is using javascript

to
format certain pieces of data. The offending HTML looks like this:

<scriptwriteCommas('174500')</script

What it's meant to do is clear but what happens when the page is imported

is
that the number is not imported. Since these are prices they then to be
kinda important :)

Any ideas how to deal with this problem? Excel 2003

TIA,

Tony