Hi,

I am using the ADO to retreive data from one worksheet from one book and
into another book. I used sqSQL for the sheet search:

rsdata.Open szSQL, ...

where szSQL = "SELECT * FROM [Combined TG and TN$]"

The sheet name from the book is "Combined TG and TN". Is there any way
to format this so that this can be recognized? I know I should not be using
long names with spaces, but I am not allowed to change the name.


Thanks,

Roel