A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Web Query (Excel 2003)



 
 
Thread Tools Display Modes
  #1  
Old June 18th, 2006, 02:40 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Web Query (Excel 2003)

I'm trying to create a workbook that queries financial data (multiple tables)
from MSN. I can get the data queried just fine into different worksheets,
but I can't figure out on my main worksheet, which performs different
calculations from data queried on the other worksheets, how to enter a stock
symbol and after hitting enter, have it refresh the data with my new query.

For example, I have 3 financial statements queried in 3 different
worksheets. I also have another worksheet that queries stock quotes. On my
main worksheet (different than the other 4) I would like to be able to type
the stock symbol in a cell, which would then import the data (stock quote and
financial statements) into the other spreadsheets.

I know my question is long winded, but I hope it makes sense to somebody.
I'm trying to automate a labor intensive job I'm currently doing.

Thanks!
  #2  
Old June 18th, 2006, 01:17 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Web Query (Excel 2003)

It sounds like you may be able to use parameters to do what you want. Here
is a link that may help.
http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
Carlos

"Dawgman" wrote in message
...
I'm trying to create a workbook that queries financial data (multiple
tables)
from MSN. I can get the data queried just fine into different worksheets,
but I can't figure out on my main worksheet, which performs different
calculations from data queried on the other worksheets, how to enter a
stock
symbol and after hitting enter, have it refresh the data with my new
query.

For example, I have 3 financial statements queried in 3 different
worksheets. I also have another worksheet that queries stock quotes. On
my
main worksheet (different than the other 4) I would like to be able to
type
the stock symbol in a cell, which would then import the data (stock quote
and
financial statements) into the other spreadsheets.

I know my question is long winded, but I hope it makes sense to somebody.
I'm trying to automate a labor intensive job I'm currently doing.

Thanks!



  #4  
Old June 18th, 2006, 04:58 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Web Query (Excel 2003)

Thank you, I'll try this and see if it works. Thanks Carlos.

"Carlos Antenna" wrote:

It sounds like you may be able to use parameters to do what you want. Here
is a link that may help.
http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
Carlos

"Dawgman" wrote in message
...
I'm trying to create a workbook that queries financial data (multiple
tables)
from MSN. I can get the data queried just fine into different worksheets,
but I can't figure out on my main worksheet, which performs different
calculations from data queried on the other worksheets, how to enter a
stock
symbol and after hitting enter, have it refresh the data with my new
query.

For example, I have 3 financial statements queried in 3 different
worksheets. I also have another worksheet that queries stock quotes. On
my
main worksheet (different than the other 4) I would like to be able to
type
the stock symbol in a cell, which would then import the data (stock quote
and
financial statements) into the other spreadsheets.

I know my question is long winded, but I hope it makes sense to somebody.
I'm trying to automate a labor intensive job I'm currently doing.

Thanks!




 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Update query to linked excel file fails in 2003 olsen9988 Running & Setting Up Queries 2 November 9th, 2005 09:11 PM
How to remove a query prompt in Excel 2003 Frustrated General Discussion 1 November 2nd, 2005 06:21 PM
New web query with Excel Pro Edition 2003 Chandler Links and Linking 2 December 15th, 2004 07:03 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Setting Up & Running Reports 1 December 13th, 2004 08:54 PM
export 1 query 5 times to 1 excel file Mike_Walrus Running & Setting Up Queries 7 June 20th, 2004 01:09 AM


All times are GMT +1. The time now is 01:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.