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

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
mxgroggAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

byundtCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Apple Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.