how do i reference a cell with url for web query import?
 

I'm trying to build a database with information that is updated 2-3 times a
week at a source website.
The urls for web query import are added to the source website with each of
these updates. I have created a page that captures all of these updated urls
but I don't wish to manually build a web query for each update.
Is there a way to link a CELL with the new url, to each new web query import
instead?

how do i reference a cell with url for web query import?
 

You can store these in a cell, yes. When you import them are they not already
in cells?
Not sure how you have this set up to be more specific but check out this site
http://support.microsoft.com/default.aspx/kb/213730

you can store the url from a cell as a variable and use it with this then
loop to the next. Start with this and if it doesn't work for what you need we
can adjust given more info.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"fkendrick" wrote:

I'm trying to build a database with information that is updated 2-3 times a
week at a source website.
The urls for web query import are added to the source website with each of
these updates. I have created a page that captures all of these updated urls
but I don't wish to manually build a web query for each update.
Is there a way to link a CELL with the new url, to each new web query import
instead?