Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Import = New web query
Hello
In excel 2003, I'm using the import new web query, to show search engine results for my various domains. It works well for google and as an example, the data imported shows as follows: Results 1 - 10 of about 35,900,000 from ibm.com for +. (0.15 seconds) However, it does not work for Yahoo and MSN. The reason for this is because there are only two tables on the entire page so the information I want is contained in the large table. So when I import data from MSN, I get a ton of garbage(see below for example) in addition to what I really need. Since I can't just import the information I need, is there any tool, or method to delete all the garbage so all that I'm left with is the one line that says "Page 1 of 3,833,126 results containing +site:ibm.com (0.07 seconds)" <= this is for the below example. I know I can manually delete what I don't need, but I have this import function set to run each time the spreadsheet opens and there are a lot of domain names, so it really isn't practical to do it by hand each time. Thank you From MSN********************** MSN Search Search: Web Desktop News Images Local (BETA) Encarta Search the web: Commands +Search Builder Settings Help Español Web Results Page 1 of 3,833,126 results containing +site:ibm.com (0.07 seconds) Results http://www.as400.ibm.com/ AS/400 home page. www.as400.ibm.com IBM United States The IBM corporate home page, entry point to information about IBM products and services ... Business consulting On Demand Business Solutions by industry IT services Software products www.ibm.com Cached page 3/4/2006 IBM Accessibility Center News Dedicated to making a difference in the lives of those with disabilities. www-3.ibm.com/able/hpr.html Cached page IBM Research IBM Research Homepage ... Additional information Careers at Research Press resources Technical paper search www.research.ibm.com Cached page 3/5/2006 IBM Research | Watson Research Center | Home Page Watson Research Center | Home Page ... Related Links Careers at Research Other Labs Local Education Outreach Project List www.watson.ibm.com Cached page 3/5/2006 IBM Redbooks Content Manager Implementation and Migration Cookbook Last updated on 3 March 2006 Virtualization on the IBM eServer xSeries 460 Server Last updated on 3 March 2006 www.redbooks.ibm.com Cached page 3/5/2006 alphaWorks : Emerging technologies alphaWorks provides direct access to IBM's emerging technology. It is a place where one can find ... AJAX Toolkit Framework The AJAX Toolkit Framework assists in constructing Eclipse framework support ... alphaworks.ibm.com Cached page 3/5/2006 Independent software vendor (ISV) resources - IBM PartnerWorld A wealth of resources available to ISVs interested in the IBM Business Partner program, PartnerWorld ... PartnerWorld Industry Networks Go further with a team you trust. Create more opportunities and close ... www.developer.ibm.com Cached page 3/5/2006 IBM Research | Almaden Research Center | Home Page IBM Almaden Research Center | Home Page ... Located in Silicon Valley, Almaden Research Center is one of eight IBM Research Division facilities ... www.almaden.ibm.com Cached page IBM Research | Projects | Blue Gene The Blue gene project is aimed at improving our understanding of the mechanisms behind protein ... Blue Gene Project Overview Hardware Science and Application Systems Software IBM Links www.research.ibm.com/bluegene Cached page Pagination 1 2 3 4 5 Next Didn't get the results you expected? Help us improve. Why does Search look like this? You are seeing this message because our stylesheet is not compatible with your browser. Search the web: Search Home MSN Search Toolbar About MSN Search Add MSN Search to Your Site MSN Home My MSN Hotmail Messenger News Headlines Feedback Advertise with Us © 2006 Microsoft. MSN Privacy RSS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import web query trouble | Excel Discussion (Misc queries) | |||
Import New Database Query (Union Query) in Spreadsheet | Excel Discussion (Misc queries) | |||
How to import web query as array? | Excel Discussion (Misc queries) | |||
new web query ( import data ) | Excel Discussion (Misc queries) | |||
Import query from Access | Excel Discussion (Misc queries) |