Hi

I have a spreadsheet with one tab having named ranges which users can select parameters. The named ranges are set up in an access database as linked tables, so that the parameters can be used in a query against tables linked from our AS-400 system.

A second tab in the spreadsheet has a macro which runs and retrieves the data from the access query. This allows users who do not have access installed to enter parameters and query the AS-400 without the need to install access or manually run reports, and cut down on time (copying & pasting, filtering etc). This all seems to work reasonably well, except for the following two hitches:

- It will not allow a requery with new parameters
- When the spreadsheet is closed, there is still an instance of excel running in the background, and the database is read-only while the other instance is running.

I have seen similar issues in various forums, but not quite the same as the setup I have - so the solutions are not exactly what I am after. Does anyone have any ideas?

Hans