PC Review


Reply
Thread Tools Rate Thread

Basic Question in Web Query...HELP!!

 
 
Rick
Guest
Posts: n/a
 
      19th Nov 2009
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!!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Basic SQL query question Xmas Microsoft Access 4 8th Nov 2009 05:27 PM
Basic SQL query question Xmas Microsoft Access ADP SQL Server 4 8th Nov 2009 05:27 PM
Update Query basic question =?Utf-8?B?RGFu?= Microsoft Access Queries 2 22nd Jun 2007 02:22 PM
Basic Query question Tom Microsoft Access 1 11th Dec 2006 04:08 AM
Basic query Question =?Utf-8?B?S2l3aSBsb3N0IGluIEFzaWE=?= Microsoft Access Queries 1 28th Aug 2004 05:04 PM


Features
 

Advertising
 

Newsgroups
 


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