I have a project centred around an Excel database. It has lots of VB
code associated with it.

The worksheet is the source data for a series of word mail merge
reports.

Here is where I hope you folks can help me ...

The data worksheet is volatile. Active worksheets are user based. They
select a date, and that date is used as part of the file name to be
loaded as the merge source. (ie 15-07-07 represents the source database
15-07-07.xls to be accessed.) Challenge # 1 - how can I use my reports
with more data source flexibility?

Second challenge ... I have 4 different reports, all relying on the
same datasource, but differeint recipient criteria. Without saving
individual reports for each different query, how can I allow the user
to define the criteria? (ie

This is all part of a project that is intended to be simple to use by
those not familiar with features and buttons of each application.

Jenn