Travel Expenses with "live" exchange rates

[Skarab]

Hi All,

our company has a basic expense form and as we're growing we're travelling to more and more places. as such i'd like to create an expense form in which you can choose the currency type by means of a simple drop-down, and the most up-to-date exchange rate will be looked up. i know how to do the excel part of this, but i don't exactly know how to import data into excel from another source (a conversion table from a site like www.xe.com) upon start-up. here's how i'm thinking it will work:
1) on startup, excel will update a lookup table (named "ex_rates") with conversion rates from another source (ideally one from the net, but i'm open to suggestions)
2) then as the user puts in a currency from the drop down the exchange rate is filled in by means of a simple look-up from ex_rates and put into a protected cell which can be seen on the front sheet.

would appreciate any help or suggestions on this.
Thanks
2)

 

[Ruddles]

If you're using 2007, go Data > From Web, and you're guided through the process of selecting a URL, identifying a table of data and then importing it into your worksheet. If you do this with the macro recorder enabled, you should end up with some VBA code will import the current version of the page. You can then call that code when the workbook opens.

Having said that, Excel couldn't identify a table on the page whose URL you posted although it managed to import the table on http://www.exchangerate.com/ without any trouble, so you may need to choose your Web page carefully.

 

[Skarab]

Thanks R,
very helpful!!!

I love this board. such a wealth of information