View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1,560
Default Stock Quotes to Excel

Hi,
Take a look at the Data Menu/Import External Data/New Web Query
David

"Angelika & Rocky Mckinley" wrote:

Hi,

Is there a way to pull stock quotes directly from the internet using Excel
vb? All I want is simple code where I read the ticker symbol in cells(1,1)
in the activesheet and it pulls the latest stock quote into cells(1,2). I
can write the rest of the code. My only hitch is that I'm running Mac
Office 2004.

Thanks in advance,

Rocky