I have created a Business Query report containing multiple queries, each of which contains a prompt for the same field (country code). Is it possible to use VBA to refresh all of the queries, passing the content of a cell to the prompts, to avoid having to repeatedly enter the same value for each query?
Taking this one stage further, is it possible to add a new query which retrieves a list of country codes, and then use VBA to refresh the other queries for each country code in this list in turn? Would it matter if this list varied in length so that a predetermined range of cells could not be identified?
This is exactly what I am trying to do also. I have not found the solution yet. Do you know how to do it by now? I would appreciate it very much if you could tell me!
No - I obviously didn’t receive a single response on how to do this, and we abandoned Business Query. Instead we are using VBA within Business Objects to export the data to Excel. I haven’t been involved with this though so don’t know the details.
This is exactly what I am trying to do also. I have not found the solution yet. Do you know how to do it by now? I would appreciate it very much if you could tell me!
(BOB member since 2007-11-12)