Tim,

Many Thanks

It worked like a dream. I may have another small issue, if so I'll title it
Activating Javascript 2

Thanks again
--
jason36


"Tim Williams" wrote:

For the button this should work:
IE.document.getElementById("btnLoad").click

Where IE is your reference to the browser app.


For the link this might also work:
IE.document.getElementById("hlExport").click

....but it really depends on what happens in the js 'exportExcel()' function.

Tim


"jason36" wrote in message
...
Tim,

The button to pull up the list of queries in the web source code is :

<input class="button" id="btnLoad" style="WIDTH: 75px"
onclick="javascript:loadQuery();"type="button" value="Load"

Followed by a link to export to an excel spreadsheet :

<br--<a id="hlExport" href="javascript:exportExcel();"Export to
Excel</a<br

The excel spreadsheet created always has the same name so that would be
the
easy part, it's just the two parts in the automation process above that
has
got me stumped.

Many Thanks

--
jason36


"Tim Williams" wrote:

If you're using the web page directly how do you run the Excel export ?
Button? Link?

Tim


"jason36" wrote in message
...
I have a problem where I want to access a website, run a query on that
particular page of the website by activating buttons displayed on the
web
page and then activate a javascript command to export the data to
excel.
I
am using Excel 2003 Professional. Is there any way possible of
automating
my
problem.
--
jason36