Does excel worksheet have unique ID?

[valk]

I writing special addin for excel, that can insert some controls into
worksheet cells.
I can identificate control by cell andress,SheetName and Workbook
name..
But in case two workbooks have identical names and worksheets have
identical names too i have a problem..
The question is: is it possible to know unique id of
workbook(worksheet)?


Thank you.
Sorry for my english..
Valentin Kovalski.

 

[mangesh_yadav]

Yes, worksheets have unique ids, as well as unique names. You cannot
have two sheets with the same name.

Mangesh

 

[Bob Phillips]

No, there is no UID as such. They have an index, but that is only relative
to the workbook.

If you need such a thing, you will need to build it.

 

[valk]

Two workbooks can have same names of worksheets! When its opened both
can't identificate my control.
I am already found, that range have ID, but that property doesn't sav
with workbook.
How to get Worksheet ID? It doesn't have that property.

Thank you for help

 

[William Benson]

A single instance of Excel does not let you open two worksheets with the
same name, so no issue. If you had two instances of Excel open, they
couldn't refer to one another without some fancy API code I suspect, so no
issue either.

 

[mangesh_yadav]

You could refer to each sheet, by its parent workbook. Something like:
Workbooks("file_name").Worksheets("Sheet1")

Manges

 

[Tom Ogilvy]

I believe you mean workbooks rather than worksheets.

For the OP, Just to summarize:

A single instance of Excel will not permit two workbooks to be open that
have identical names.

Likewise, within a single workbook, you can not have two sheets with
identical names. You can have duplicate sheet names within open workbooks,
however. Both workbookA and WorkbookB can have a sheet named Sheet1.
However, the full reference (not name) to the sheet would include the
workbook, so there would be no confusion.

 

[valk]

Thanks a lot, but my problem was in another place :

 

[William Benson]

Yep, meant workbooks ... all niter.

B.

I believe you mean workbooks rather than worksheets.

For the OP, Just to summarize:

A single instance of Excel will not permit two workbooks to be open that
have identical names.

Likewise, within a single workbook, you can not have two sheets with
identical names. You can have duplicate sheet names within open
workbooks,
however. Both workbookA and WorkbookB can have a sheet named Sheet1.
However, the full reference (not name) to the sheet would include the
workbook, so there would be no confusion.

 

[William Benson]

We've all been in that "other place" at one time or another in our
lives..........