How do I paste URL for web query with Excel2003

  • Thread starter Thread starter ian.qmulus
  • Start date Start date
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
 
You can record a macro of making the change and then modify the macro to
accept variables

Post a few of the urls.
 
Back
Top