I have an extensive Access database that folks are always wanting to export
to excel. I've set up a table of query names/descriptions for export queries
I've developed. Users log in, open a form (using switchboard), and select a
query description they want, point to an excel spreadsheet where they want it
exported, then click a button, it gets exported using the access
transferspreadsheet method.

I'd like to reverse the process. I'd prefer to keep people out of my db and
have 'em "suck" those query results into a spreadsheet instead. I'm sure I
can do this, but I need some structural advice. I'm comfortable with vba,
though not a whole lot of work in excel vba (Access, and believe it or
not...Project vba.)

So, presumably, I'd create some selection table by sucking in the already
existing table from Access, then use that to select the query the user wants,
then pull that query into a sheet by itself.

Strategies?
--
Jim