How do I paste URL for web query with Excel2003

I

ian.qmulus

I'm trying to use the web query function.

When I choose data/ import external data/new web query only my home
page comes up. I cant paste a new URL in the address bar of the edit
web query window. I can highlight and type in a URL. Any way I can
easily select a new URL for a web query.

Thanks
 
D

Don Guillett

You can record a macro of making the change and then modify the macro to
accept variables

Post a few of the urls.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help - Excel 2007 web query feature 4
Web Query for list of DVD's 0
strange web query behavior 0
AppleScript - How do I select a text ? 1
edit web query 5
Input Real Estate Data into Excel 2
Web Query 0
Web query misbehaviour. 2

Top