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

Web query misbehaviour. 2
Help - Excel 2007 web query feature 4
edit web query 5
Error: This Web query returned no data 1
Input Real Estate Data into Excel 2
Importing a Web Query 4
WEB Query 1
Excel Web Query 3

Top