javascript causing web query problems
 

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

javascript causing web query problems
 

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

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