External data query

[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?

 

[Gord Dibben]

Data>Import External Data>Edit Query.

Change the URL


Gord Dibben MS Excel MVP

 

[Nondisclosure007]

Data>Import External Data>Edit Query.

Change the URL

Gord Dibben  MS Excel MVP




- Show quoted text -

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

 

[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.

 

[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 -

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