get excel sheet name

[charon]

Well, may I know how to get the excel worksheets name via ADO.
I want is sheet name, not file name.
pls advice.

[Roelf]

activesheet.name ???

[glenngv]

I don't know if this link will give you the answer.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnasdj01/html/asp0193.asp