Ann Marie, All I can say is "wow". I understand everything you put in your notes -- I'll just have to carve out a bit of time and give them a try. Good learning experience. Dave Composed on a Dell Latitude 630 in the general vicinity of my Audio Recording and Mixing Studios, San Francisco Bay Area. ----- Original Message ----- From: Ann Marie Medlar To: jfw@xxxxxxxxxxxxx Sent: Saturday, March 05, 2011 13:47 Subject: Re: Excel 2003 Web Query Smart Tag definition? Hi, I am still working on this project. But if I figure it out it is so easy to access important info from sites. I can create a company report if you are interested which gives a summary what a company does and other financial info. If one has an interview it would be easy to research about that company in a couple minutes. Also if you wish to buy a stock it might give you some insights. But this tool is endless to do specific research on anything. Jaws research it feature is similar and I just downloaded the info from FS site. Hope to be able to get info more easily so I'll keep working on this. Here are my Excel notes: Download link for Excel spreadsheet with a web Query for stock quotes called StockQuoteTemplate.xls You may Need to copy and paste link into your browser because link name is too long. http://webcache.googleusercontent.com/search?q=cache:FS7e8sn8rlQJ:www.vertex42.com/ExcelTemplates/excel-stock-quotes.html+Link+StockQuoteTemplate.xls&hl=en&gl=us&strip=1 Enter on text only version and read page until download link or Type "H" twice for download After downloading and opening Excel spreadsheet called StockQuoteTemplate.xls 2 buttons appear Press button that Enables data to be refreshed press control +G for GoTo Excel command type c6 and enter Type stock symbol and enter go to b11 right and left arrow for company stock quotes On B11 enter on stock symbol to link to web to get company report use insert+f7 enter on print report link type x and check company report type b for button enter on generate report new browser window opens enter on print link company report displayed on screen which looks like a PDF Other notes: Press alt+F5 key to refresh There are many links on this page as well. It is easier navigating site using this work book. Microsoft link for Excel Web Queries: http://msdn.microsoft.com/en-us/library/aa203721(v=office.11).aspx#odc_xlwebquery_introduction Smart Tag link: http://webcache.googleusercontent.com/search?q=cache:8Aft_cEwD5wJ:support.microsoft.com/kb/289148+Add+smart+tag+Excel+2003&cd=1&hl=en&ct=clnk&gl=us&source=www.google.com ----- Original Message ----- From: Farfar Carlson To: jfw@xxxxxxxxxxxxx Sent: Friday, March 04, 2011 6:27 PM Subject: Re: Excel 2003 Web Query Smart Tag definition? Ann Marie, You're way above my head. I'm going to keep your name on my list if I have any Excel questions. Sorry I can't help. Dave Composed on a Dell Latitude 630 in the general vicinity of my Audio Recording and Mixing Studios, San Francisco Bay Area. ----- Original Message ----- From: Ann Marie Medlar To: jfw@xxxxxxxxxxxxx Sent: Friday, March 04, 2011 11:55 Subject: Re: Excel 2003 Web Query Smart Tag definition? Hi all, I am trying to define a smart tag for company report in Excel 203 to go to the MSN central money site. Right now if you enter a stock ticker symbol in c6, the stock price action is populated in B11:q11 or so. If I enter on B11 I go to site and company report is a check box under print report. So I would like to link the new company report smart tag to this site so the company report will be included on spread sheet.