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:

<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

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." <[email protected]> wrote in message
news:[email protected]...
> 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

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." <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>