[AccessD] A2010 - Export Query Results to Excel - Plus some other bits

[Darren - Active Billing]

Hi All,

Long time no post - Don't do much Access stuff these days, but I have a Not-For-Profit pro-bono job (Rewriting something from 15 years ago)


The Situiation:

I have some queries that need to be output to excel. I managed to get that bit to work.

And the process I have adds the Column header names - So that’s cool - And the Naming of the file and the naming of the Worksheet tab all works ok.

So that all works OK for one query, outputting to one Excel File, with one Worksheet (one tab)


The Question:

But…there is a need to add tab, after tab, after tab, named by date (dd_MMM_yyyy) of essentially the same data/queries. 

(Users want to see their incremental changes organised by date named tabs)

So…what I really need is to be able to output the results of a query to a known/existing Excel file, but in a new worksheet (new tab) and to be able to name this new tab as I do so.


Nice to have:

And if possible is it possible to see if a TAB name of the dd_MMM_yyyy exists and then just append the new tab with something like dd_MMM_yyyy_x

(though that request above is not essential as I can just add a time component to the name to solve that issue) 

Make sense?

Many thanks in advance, team

Darren