Thread: Automatic Exchange Rates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Automatic Exchange Rates
First of all you can go to DataImport External DataImport Date

Select the MS MoneyCentral Investor Rates.iqy

Dump to a new worksheet.

DataRefresh whenever you like.

If you want a timed refresh, see Chip Peraron's site for OnTime code.

http://www.cpearson.com/excel/ontime.htm


Gord Dibben MS Excel MVP

On 18 Dec 2006 11:05:22 -0800, "Why Tea" wrote:

Is there a way to program a worksheet to have exchanges rates
automatically updated from the Web?

/Why Tea

Reply With QuoteReply With Quote