External data query

  • Thread starter Thread starter Nondisclosure007
  • Start date Start date
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?
 
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.
 
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.
 
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.
 
Back
Top