Hi,

I want the user to give a "start" and "end" date on an xl SS, then query an
Access DB for specific data. I've created another Access database that does
a link-query (is that correct name?) to the 'Main' database, but would rather
go the Excel SS route since this is where the report is created.

Is it possible to make a Vis. Basic code that will just query the "Main"
database for this data, and create a worksheet for this?

Each report is saved as a separate Excel file.

thanks!

matt