How to create a Web query in Excel?

E

Eric

The traditional method of creating a web query uses the New Web Query menu
command found on the Data menu under Import External Data. It will be easy to
retrieve all data within the specific web page. Does it have any advance
features on selecting specific area of data within the web page? for example,
when I import the web link http://finance.yahoo.com/q?s=^DJI, 12266.39 in
cell B45, I only want to load this value within this cell for this web link.
Does anyone have any suggestions on how to do it?
Thank anyone very much for any suggestions
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to insert web page content into excel worksheet? 1
How to import web link and avoid frame? 3
Web Query 0
web query 5
Create a chart from a table in word thats dynamic 0
Web Query in Excel 0
How to import external data into excel? 2
Invalid web query Excel 2007 0

Top