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

[Darren - Active Billing]

Hi Stuart,

Thanks for this - I did miss this post back in June.

I am seeing Underscores preceding the TAB Names - And was going to investigate once I had a working set of screens (That manages the XL files)

At present them starting with an Underscore kinda suits.

For my limited usage requirements I have a satisfactory implementation that should suit - and Yes, "range:=" was what was needed as per Ryan’s suggestion

Thank you all of jumping in

Darren


---------------------------------------------------------------------
> On 15 Aug 2023, at 10:37 pm, Stuart McLachlan <stuart at lexacorp.com.pg> wrote:
> 
> 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
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com