| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does excel worksheet have unique ID?
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. -- valk ------------------------------------------------------------------------ valk's Profile: http://www.excelforum.com/member.php...o&userid=23881 View this thread: http://www.excelforum.com/showthread...hreadid=375185 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Does excel worksheet have unique ID?
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. -- HTH Bob Phillips "valk" wrote in message ... 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. -- valk ------------------------------------------------------------------------ valk's Profile: http://www.excelforum.com/member.php...o&userid=23881 View this thread: http://www.excelforum.com/showthread...hreadid=375185 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Does excel worksheet have unique ID?
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. "valk" wrote in message ... 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. -- valk ------------------------------------------------------------------------ valk's Profile: http://www.excelforum.com/member.php...o&userid=23881 View this thread: http://www.excelforum.com/showthread...hreadid=375185 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Does excel worksheet have unique ID?
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. -- Regards, Tom Ogilvy "William Benson" wrote in message ... 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. "valk" wrote in message ... 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. -- valk ------------------------------------------------------------------------ valk's Profile: http://www.excelforum.com/member.php...o&userid=23881 View this thread: http://www.excelforum.com/showthread...hreadid=375185 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Does excel worksheet have unique ID?
Thanks a lot, but my problem was in another place : -- val ----------------------------------------------------------------------- valk's Profile: http://www.excelforum.com/member.php...fo&userid=2388 View this thread: http://www.excelforum.com/showthread.php?threadid=37518 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Does excel worksheet have unique ID?
We've all been in that "other place" at one time or another in our
lives.......... :-) "valk" wrote in message ... Thanks a lot, but my problem was in another place :) -- valk ------------------------------------------------------------------------ valk's Profile: http://www.excelforum.com/member.php...o&userid=23881 View this thread: http://www.excelforum.com/showthread...hreadid=375185 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Does excel worksheet have unique ID?
Yep, meant workbooks ... all niter.
B. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Does excel worksheet have unique ID?
Yes, worksheets have unique ids, as well as unique names. You cannot have two sheets with the same name. Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=375185 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Row and Corresponding Unique Worksheet | Excel Worksheet Functions | |||
| I need a unique number to be created per worksheet | Excel Discussion (Misc queries) | |||
| listing unique entries from the entire worksheet | Excel Worksheet Functions | |||
| Copy Unique data to a different worksheet | Excel Discussion (Misc queries) | |||
| using macro to save worksheet with unique file name | Excel Programming | |||
Hybrid Mode
