sheetid

[NavinReddy]

Dear All, How can i get my sheetid , i want to create one variable i need to assign sheet id to that variable Best Regards, Niranjan

[MK_QSL]

GetActiveSheetID()

[#3]

go to sheet properties an have look at image

[#4]

Hi,

You can simply right click on your sheet, go to Properties--Genral tab and you will find Sheet ID there.

Or you can use GetActiveSheetID() function in a text box as suggested by Manish to get Sheet ID.

Hope this helps!

[NavinReddy]

Hi manish,

That gives Document\SH01

how can i get only SH01

Thank you so much for reply

Regards,

Niranjan

[jagan]

Hi,

Try GetActiveSheetID(), will give you the Current sheet ID.

vCurrentSheetID = GetActiveSheetID()

Regards,

Jagan.

[MK_QSL · Accepted solution]

=SubField(GetActiveSheetId(),'\',2)

[NavinReddy]

Hi Jagan,

That gives Document\SH01

how can i get only SH01

Regards,

Niranjan

[jagan]

Hi,

Try this

=SubField(GetActiveSheetId(),'\',2)

Regards,

Jagan.

[#10]

=SubField(GetActiveSheetId(),'\',2)