LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to create a Web query in Excel?

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=%5EDJI, 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can rights to run but not create a query in excel an option? RyanS Excel Discussion (Misc queries) 0 August 15th 07 02:02 PM
how to create a web query TUNGANA KURMA RAJU Excel Discussion (Misc queries) 1 February 7th 07 09:05 AM
Web query to create historical stock data ChrisT New Users to Excel 3 April 25th 06 01:43 AM
How do I create a query field in Excel Sean Excel Discussion (Misc queries) 1 July 20th 05 08:47 PM
how to create button commande to refresh data in query in excel 2. Jean-Francois Excel Discussion (Misc queries) 1 January 6th 05 08:03 PM


All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"