External data query

N

Nondisclosure007

No questions on setting it up, but where does it store that
information? I want to be able to allow a user to change the URL
(data on the new URL is in the SAME exact format as the one when it
was first setup).

Is this possible?
 
N

Nondisclosure007

Data>Import External Data>Edit Query.

Change the URL

Gord Dibben  MS Excel MVP




- Show quoted text -
Click to expand...

Well, I was hoping for something like putting the settings in a
sperate sheet. Then they can then update the query.
 
D

Don Guillett

Set up your query and then record a macro using what Gord said. Then, modify
the result to allow for the variable. Send your file to my address below if
you like with details.
 
N

Nondisclosure007

Set up your query and then record a macro using what Gord said. Then, modify
the result to allow for the variable. Send your file to my address below if
you like with details.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software






- Show quoted text -
Click to expand...

Thanks Don. I'll try it first. And, after a while, I can't get it,
I'll send it.
 
Top