View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PS PS is offline
external usenet poster
 
Posts: 18
Default Retrieving Exchange Rate Data from a Website

Please bear with me. I am such a beginner user of VBA, I can be considered a
pre-user!
I would like to retrieve the daily exchange rates for a particular currency,
convert it into US dollars and insert it into my worksheet. We typically use
http://moneycentral.msn.com/investor...cconverter.asp.
Can I automate this process so the user is prompted to enter the $ amount,
'currency from' and 'currency to', without having to leave the worksheet?
Any help would be appreciated and bear in mind my knowledge is elementary at
best.
Thanks
Patricia