wailingrecluse
Registered User.
- Local time
- Today, 06:57
- Joined
- Feb 10, 2009
- Messages
- 50
Hi all
I hope someone can offer a solution to this:
I currently have a workbook, which has several sheets, each one pulling a seperate report using a web query.
This was created recently using a previous weeks reports, but having come in this morning ive discovered that the URLs seem to change slightly, which stops the queries from running.
Is there a way to create a form in which the new number can be entered, which will then go and update all the queries?
there is a number in the web query eg 044,020 which has changed this week to 044,009
Fortunately all the reports are the same in this respect, so if i could run something to change that number on all queries that would be great
Any ideas?
I hope someone can offer a solution to this:
I currently have a workbook, which has several sheets, each one pulling a seperate report using a web query.
This was created recently using a previous weeks reports, but having come in this morning ive discovered that the URLs seem to change slightly, which stops the queries from running.
Is there a way to create a form in which the new number can be entered, which will then go and update all the queries?
there is a number in the web query eg 044,020 which has changed this week to 044,009
Fortunately all the reports are the same in this respect, so if i could run something to change that number on all queries that would be great
Any ideas?
