Web Query problems in Excel 97
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Web Query problems in Excel 97

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Atlanta
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I work on an ancient NT machine at work that only has Excel 97 installed. Our administrator locks just about every function on our machine, so I am unable to create a web query using the wizard in Excel. To make matters easier, I created the correct query on another machine using Excel 2000, then saved it as an iqy file and ran it on my work machine in Excel 97. My query works in 2000, and only displays the tables on the website that I specify (i.e tables 2 and 6). This keeps the data consistent and brief, which is what I want since this encompasses a lot of data and formulas. However, when I run the query in 97, ALL of the tables on the webpage that I am getting data from appear. What a nightmare! It makes formulas useless, as some of the requested data may be in 8 rows and 15 columns while others are in 11 rows and 33 columns. And not only do I have inconsistent data entries, but I also have a page full of links to other sites, all of which are not necessary. Any of you know the VB codes to only extract data from certain tables in 97? I don't know if it is possible, as the web query tools are different in 97 and 2000 (or 2002/XP, etc).

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi --

    Good question and i like that one!

    XP will argue with 97 on web based stuff as a general rule, 2000 will be grumpy with some issues,

    I would wait till XP or 2000 arrives and then work it else codes will need to check the OP and select case to suite, also case select the version... not good

    A big thanks to Microsoft again i feel.


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com