Importing Data via Web Query - Can values be passed to query?

J

jgalenski

Thank AP,

This enables me to build a link within a Spreadsheet; however, I'm
trying to use the dynamic link to load external data via the Data ->
Import External Data -> New Web Query utility. I could not dynamically
construct the URL.

-johng
 
G

Guest

Was going to ask the exact same question as you John. Would love to know if
this is possible. Can't find the issue being discussed earlier.

/Mitch

"(e-mail address removed)" skrev:
 
G

Guest

Let me clarify my problem. The main data source I want to use with web query
is updated daily and the URL is also changed daily. So I can't use a static
web query and get the updated site.

Well, at least I managed to figure out how the URL is named and this info is
available in another web query I've done which doesn't change it's address.

So I'm stuck with the info on how the main source names it's URL after
updating it but I can't figure out how to make the web query for it with the
URL being dynamic, albeit existing in a cell already.

Example:

First I web query one site and get a number which is changed daily, today
its 131.

ok, so know I want to use this number (represented by the XXX) to get data
from a site with thte following URL:

http://www.domainname.com/website/html/web/XXX.shtml

I might add that there's several of these that I need to do otherwise I
would have done it manually.

Any help here would be greatly appreciated.

Regards


"Ardus Petus" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top