View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Validea1@gmail.com is offline
external usenet poster
 
Posts: 1
Default VBA Code To Import Historical Stock Quotes In Excel

Does anyone know/are able to write a VBA code that would let the user
type in a date and ticker symbol and have excel automaticly grab the
historical quote off of Yahoo!Finance ? i.e. type "8/29/2005" in A1 and
"MSFT" is B1 and have the adj. Close appear in C1... Any help would be
greatly appreciated.