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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top