How do I paste URL for web query with Excel2003

's Computer Specifications

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

's Computer Specifications

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

Post a few of the urls.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I paste WITHOUT cell references changing (and without usingabsolute cell addresses) [EXCEL2003 SP3]	ship	Microsoft Excel Discussion	8	10th Nov 2008 12:24 PM
Paste Excel2003 to Word2003	Gizmo	Microsoft Excel Programming	0	15th May 2008 08:00 PM
Paste error from Query	=?Utf-8?B?R3JhaGFtVg==?=	Microsoft Excel Misc	0	2nd Feb 2007 11:47 AM
Cannot get Wildcards in Parameters to work in MS Query/Excel2003	=?Utf-8?B?SmFuIEs=?=	Microsoft Excel Misc	3	17th Feb 2006 06:00 PM
MS-Query code from EXCEL97 doesn't work in EXCEL2003 ??	=?Utf-8?B?bG41NA==?=	Microsoft Excel Misc	4	21st Feb 2005 08:12 PM