javascript causing web query problems

[Guest]

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:

<script>writeCommas('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

 

[Tim Williams]

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.

 

[Guest]

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

T.