Hello;
I'm not sure where to put this ?. Hope someone can provide some insight.
It may not be something I can accomplish solely w/Excel.

I want to get the foreign exchange rates everyday & store them in a master
workbook. Best reference I found so far --
http://today.reuters.com/Investing/Currencies.aspx -- if someone has
something better, like that shown in the Wall St. Journal, I'd be happy to
use that, as well.
Anyway, I'd like to use the "export to Excel" right click drop down feature,
and save the rate table in a worksheet. I wanted to automate it to retrieve
the information automatically.

I know I can schedule a task to open excel at the same time every day,
write a macro to open a workbook,
go to the site by executing a hyperlink,
once there do the right click thingy (how do I get it to do this
automatically?)
have it skip from the last end point of entry and insert new info into the
next row (can figure this out myself, sort of)
save & close the workbook
close the Excel application

How do I get it to "copy/export" from the internet automatically? Is there
even a way to do so?

As always, guidance, suggestions, alternate methods will be greatly
appreciated.

Thanks everyone.

PS