Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
import web query trouble steven Excel Discussion (Misc queries) 0 March 2nd 10 01:52 PM
Import New Database Query (Union Query) in Spreadsheet klock Excel Discussion (Misc queries) 2 September 24th 09 01:30 AM
How to import web query as array? Sam_stock Excel Discussion (Misc queries) 0 April 26th 07 03:58 PM
new web query ( import data ) Josh Excel Discussion (Misc queries) 0 January 18th 06 02:52 AM
Import query from Access Kmarie Excel Discussion (Misc queries) 2 May 21st 05 04:00 AM


All times are GMT +1. The time now is 01:19 AM.

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

About Us

"It's about Microsoft Excel"