I'm running a macro which transfers 5 Access tables weekly into one new table. The import file name changes every week, so can I create a prompt "Amend Import File Name!", such that I do not have to keep amending 5 Append Queries before I start the macro?

The file name has a pattern, e.g

AB##-01-09-01, where both ## and the date need to change.
Many thanks any help on this.

Create a form with a text box and a command button. Use this referance in the Queries instead of the Hardcoded name:

Forms![YourFormName].[TextFieldName]

Make sure to validate that the Text field has a valid formated name on the Click Event of the Button prior to running your Queries.

Tks for input, Travis, but I'm not sure where to place the Forms reference in the queries, such that it would replace the task of right-clicking the mouse, click properties, and changing path details e.g c:/unzipped/ab##01-09-01.mdb.