imported_unknown
Active Member
- Joined
- Jan 13, 2002
- Messages
- 424
Hi,
I am trying to download a variety of stock data from the web using a web query that allows inputing certain parameters (specifically a stock quote symbol). The other posts were very helpful as was the Web Connectivity kit. However, when I use the three line web query below it works, whereas the four line web query does not. Any suggestions as to what I'm doing wrong on the 4 line web query?
3-Line Query:
WEB
1
http://moneycentral.msn.com/scripts/webquote.dll?ipage=qd&Symbol=["Symbol","Enter Stock Symbol"]&SUBMIT1=Go
4-Line Query:
WEB
1
http://moneycentral.msn.com/scripts/webquote.dll
ipage=qd&Symbol=["Symbol","Enter Stock Symbol"]&SUBMIT1=Go
Furthermore, when I try and edit query 3 once I've run it in Excel, it takes me to the web page and allows me to check/uncheck the tables I want. Fine. However, once I import the form back in to Excel, it automatically converts to a static query as opposed to a query with the Symbol parameter that I can modify.
If any of you have any suggestions, it would be much appreciated!
Thanks,
Laurance
I am trying to download a variety of stock data from the web using a web query that allows inputing certain parameters (specifically a stock quote symbol). The other posts were very helpful as was the Web Connectivity kit. However, when I use the three line web query below it works, whereas the four line web query does not. Any suggestions as to what I'm doing wrong on the 4 line web query?
3-Line Query:
WEB
1
http://moneycentral.msn.com/scripts/webquote.dll?ipage=qd&Symbol=["Symbol","Enter Stock Symbol"]&SUBMIT1=Go
4-Line Query:
WEB
1
http://moneycentral.msn.com/scripts/webquote.dll
ipage=qd&Symbol=["Symbol","Enter Stock Symbol"]&SUBMIT1=Go
Furthermore, when I try and edit query 3 once I've run it in Excel, it takes me to the web page and allows me to check/uncheck the tables I want. Fine. However, once I import the form back in to Excel, it automatically converts to a static query as opposed to a query with the Symbol parameter that I can modify.
If any of you have any suggestions, it would be much appreciated!
Thanks,
Laurance