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

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" <(E-Mail Removed)> wrote in message
news:26abd15c-3b4b-477a-9cc5-(E-Mail Removed)...
> 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