How to easily run WebQueries in Mac Excel like i could in Win Excel

Posted on 2004-12-01
Last Modified: 2010-04-25
I am working in Excel X for mac Service Release 1 and trying to do web queries like i can in Excel on my
PC.  I can't get to my pc to find the correct procedure, but i dont remember it being this hard to find.  Help files are of no use.

I want that "web query" wizard like on my pc where i can navigate to the correct page, select the table to import and everything. I just cant find it in mac excel.

Could you please tell me how to do it, step by step without having to make my own queries in a text file like microsoft says?

If this is not possible in mac Excel, is there a free third party software or add-on that can do the same job, that can be run by an excel macro?

Please help
Question by:mxgrogg
    1 Comment
    LVL 80

    Accepted Solution

    I don't see a web query wizard in my copy of Excel X either.

    Apparently, Microsoft expects us to edit a query file. You access those from the Data...Get External Data menu item. Choose the Run Saved Query, then double-click one of the four sample queries and modify it. But I couldn't modify the web query very much.

    I next created a web query file *.iqy in Excel 2000 and imported that into Excel X. Still a pain in the butt, but at least I was using a real wizard to build the web query. FWIW, Excel 2003 does it much nicer than Excel 2000.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Steve Jobs once said that Blu-ray is "a bag of hurt". As Macs users well known, things haven’t settled down (at least not from Apple’s perspective). Several years after that comment, Mac OS X still doesn’t support Blu-ray playback, nor has any Mac s…
    A lot of new and distinct gadgets are making their appearance every other day. The latest gadget that has wooed the attention of all gadget lovers and non gadget lovers alike is the Smartwatch. This tiny gadget is capable of offering live access to …
    Users will learn how resize a batch of photos from a single command in Photoshop via Photoshop's Image Processor. Open up an Image you'd like to resize in Adobe Photoshop: Adjust the image size according to your preferences. Image > Adjustments > …
    Users will learn how to set proper sequence settings, scale images, paste attributes, add transitions, fades, and music. Open up Final Cut Pro 7 and Create a new Project: Set the Sequence Settings. a) Click File > Easy Setup > Format > Apple ProRe…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now