ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Basic Question in Web Query...HELP!! (https://www.excelbanter.com/excel-discussion-misc-queries/248843-basic-question-web-query-help.html)

Rick

Basic Question in Web Query...HELP!!
 
This is probably a very basic question, but I am stuck and would appreciate
any assistance from the forum.

What I am try to do is import stock market data from
http://moneycentral.msn.com into an Excel spreadsheet (Excel 2000). The URL
is (example):

http://moneycentral.msn.com/investor...sp?SYMBOL=MSFT

Running a web query dumps the entire webpage onto the spreadsheet, but all I
want is one of the values (eg Close). How do I limit the data to just one
cell in the external table downloaded to one cell in my spreadsheet??

Sorry for the basic question...there must be a simple way to do this!!


All times are GMT +1. The time now is 06:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com