Web Query in Excel 2007

[dhstein]

I can't find a good reference on how to import data from the web into Excel
2007. I want to learn the general approach, but as a learning tool I'll
start with a stock portfolio in Google. Any suggestions would be
appreciated. Thanks.

David

 

[Don Guillett]

The easiest way to do this is to goto the google portfolio area>place your
cursor in the field (try between col 1 and col 2 of the portfolio)>right
click>export to excel>>>>>>> Go from there with a macro to do as desired.

 

[dhstein]

Thanks Don. That did the trick.

The easiest way to do this is to goto the google portfolio area>place your
cursor in the field (try between col 1 and col 2 of the portfolio)>right
click>export to excel>>>>>>> Go from there with a macro to do as desired.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

Glad to help