Web Query in Excel 2007

D

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
 
D

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.
 
D

dhstein

Thanks Don. That did the trick.



Don Guillett said:
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
[email protected]
Click to expand...
 
Top