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.
 

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

Similar Threads

Web Query Auto Refresh 2
Keeping web query cells attached to other data. 3
Excel Import External Data by Date Automatically 0
Creating a Web Query 4
Import Data -- External Web Query 1
How do you get information from an Excel Web Query into Access? 3
Reference web query data in seperate worksheet 1
Web queries 2

Back
Top