If you can post the code your using, it might be easier to make a suggestion
to get what you would like...


Mark Ivey


"todtown" wrote in message
...
I have code in a workbook that uses ADO to query data from another
workbook. I want to get the name of the worksheet in the workbook
being connected to. How do I do that?

tod