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

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

This probably has everything you could want or need:
http://groups.yahoo.com/group/xltraders/

Create an account (if you don't have one), login, and click 'Files' on the
upper left hand side of your screen.

Also, if you use MS Explorer, you can get on a stock-related web site,
right-click, and click 'Export to Microsoft Excel'.

Regards,
Ryan---

--
RyGuy


"David" wrote:

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

I have some free files there under donaldb36 but I don't think there are
many for mac

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ryguy7272" wrote in message
...
This probably has everything you could want or need:
http://groups.yahoo.com/group/xltraders/

Create an account (if you don't have one), login, and click 'Files' on the
upper left hand side of your screen.

Also, if you use MS Explorer, you can get on a stock-related web site,
right-click, and click 'Export to Microsoft Excel'.

Regards,
Ryan---

--
RyGuy


"David" wrote:

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

Excel 2004 for Mac doesn't seem to recognize this command and I can't find
any vb help on it either, so maybe it doesn't exist.

Rocky


On 4/21/08 6:19 PM, in article
, "David"
wrote:

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

Hi I tried what you said and created an account but none of the files
actually worked in excel 2004 for Mac. Too bad I'd like to pull live quotes
in and manipulate them for analysis.

Regards,
Rocky


On 4/22/08 8:18 AM, in article
, "ryguy7272"
wrote:

This probably has everything you could want or need:
http://groups.yahoo.com/group/xltraders/

Create an account (if you don't have one), login, and click 'Files' on the
upper left hand side of your screen.

Also, if you use MS Explorer, you can get on a stock-related web site,
right-click, and click 'Export to Microsoft Excel'.

Regards,
Ryan---

Maybe?? this will help
http://www.google.com/search?sourcei...or+excel+ mac

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Angelika & Rocky Mckinley" wrote in message
...
Hi I tried what you said and created an account but none of the files
actually worked in excel 2004 for Mac. Too bad I'd like to pull live
quotes
in and manipulate them for analysis.

Regards,
Rocky


On 4/22/08 8:18 AM, in article
, "ryguy7272"
wrote:

This probably has everything you could want or need:
http://groups.yahoo.com/group/xltraders/

Create an account (if you don't have one), login, and click 'Files' on
the
upper left hand side of your screen.

Also, if you use MS Explorer, you can get on a stock-related web site,
right-click, and click 'Export to Microsoft Excel'.

Regards,
Ryan---