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

[Stuart McLachlan]

Using Range was dscussed a couple of months ago.

You need to be careful  about how you name the new sheets:

Here's what I posted last time:

On 22 Jun 2023 at 11:49, Stuart McLachlan wrote:

> Worked it out.  Using the Range parameter to define the spreadsheet
> name applies the standard Range name conventions. There is no getting
> around that.
> 
> i.e. 
> It  must start with a letter or an underscore. If not it will get a
> preceeding underscore.
> 
> It can be any single alpha character except R or C
> 
> It cannot be interpretable as a cell value. Column names range from A
> to XFD so any one to three letters in that range followed by any
> number up to 1048576 will get a leading underscore.
> 
> It can't contain any non alphanumeric character other that
> period,question mark, underscore and backslash .All invalid characters
> are replaced by underscores.
> 
> If it conflict with any existing name, the existing sheet will be
> replaced.

and


On 22 Jun 2023 at 18:30, Stuart McLachlan wrote:

> Just picked up another factoid. If it's not a current range name, not
> only does the sheet get created with the range name, but a named range
> is also created for the data (Hit Ctrl+G in the spreadsheet and you
> will see the named ranges. )
> 
> Just found a good reference that points out a few other foibles   It's
> well worth a read:
> 
> http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#ExpRange