Further to
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.
public.excel&tid=8532b88a-79c6-4a3d-a542-fcb21327dcff&cat=en_US_e064c9ec-14bf-4e
f7-ba07-6a1970559f64&lang=en&cr=US&p=1,

Here is a list of names from all the xls files I'm working with which make
sense ...

'33 TRAILERS$'
'40 TRAILERS$'
'44-45''TRAILERS$'
'ARGOS (2)$'
ARGOS$
Barton$
Basildon$
'Basildontrailers $'
bridgtrailers$
Bridgwater$
Bruntingthorpe$
Castleford$
castlefordtrailers$
Corby$
CorbyTrailers$
'DOUBLE DECKS$'
'Fleet List$'
Heywood$
heywoodtrailers$
Lists$
'Magna Park$'
Magna$
'magnatrailers $'
'MEGA DECKS$'
Mossend$
'mosstrailers $'
'MULTI DECKS$'
peak$
'Rigid Summary$'
'SHORT TRAILERS$'
SHUNTER$
shunters$
Telford$
'Title Page$'
'TRACTOR UNITS$'
'Trafford Park$'
Trafford$
trafftrailers$
'Trailers $'
'Trunk Fleet$'
units$
WGC$
'wgctrailers $'
Wolves$

Here is a list of table names which have "other" formats ...

'33 TRAILERS$'_
'33 TRAILERS$'Print_Area
'40 TRAILERS$'_
'40 TRAILERS$'Print_Area
'44-45''TRAILERS$'_
'44-45''TRAILERS$'Print_Area
'ARGOS (2)$'_
Barton$_
Barton$Print_Area
Basildon$_
Basildon$Print_Area
'Basildontrailers $'_
bridgtrailers$_
Bridgwater$_
Bridgwater$Print_Area
Bruntingthorpe$_
Castleford$_
Castleford$Print_Area
castlefordtrailers$_
castlefordtrailers$Print_Area
Corby$_
Corby$Print_Area
CorbyTrailers$_
CorbyTrailers$Print_Area
'DOUBLE DECKS$'_
'Fleet List$'_
'Fleet List$'Print_Titles
Heywood$_
Heywood$Print_Area
heywoodtrailers$_
heywoodtrailers$Print_Area
'Magna Park$'_
'Magna Park$'Print_Area
Magna$_
Magna$Print_Area
'magnatrailers $'_
'magnatrailers $'Print_Area
'MEGA DECKS$'_
'MEGA DECKS$'Print_Area
Mossend$_
Mossend$Print_Area
'mosstrailers $'_
'mosstrailers $'Print_Area
'MULTI DECKS$'_
'MULTI DECKS$'Print_Area
peak$_
peak$Print_Area
'Rigid Summary$'_
'SHORT TRAILERS$'_
'SHORT TRAILERS$'Print_Area
SHUNTER$_
SHUNTER$Print_Area
shunters$_
shunters$Print_Area
sites
statuses
Telford$_
Telford$Print_Area
'TRACTOR UNITS$'_
'TRACTOR UNITS$'Print_Area
'Trafford Park$'_
'Trafford Park$'Print_Area
Trafford$_
trafftrailers$_
trafftrailers$Print_Area
'Trailers $'_
'Trailers $'Print_Area
'Trunk Fleet$'_
'Trunk Fleet$'Print_Area
types
units$_
WGC$_
WGC$Print_Area
'wgctrailers $'_
'wgctrailers $'Print_Area
Wolves$_
Wolves$Print_Area

I now see the Print_Area and Print_Titles are not for me in, so I'm
excluding them from my list of tables for the application to work with.

But what are the trailing _ about?