How can I get the current sheet name in a variable ?

[marcel_olmo]

I know there is a function called GetActiveSheetId() that returns the current Id, but how about the current name?

Is there any trick to solve it?

Many thanks in advance.

[pover]

In the QV API, look at the ISheetProperties Class. The following example is how to get to the name of the sheet.

set vSheet=ActiveDocument.GetSheetByID("SH03")
set sp=vSheet.GetProperties
set v = ActiveDocument.Variables("Variable1")

v.SetContent sp.Name,true

Regards.

Then to assign it to a variable

[marcel_olmo]

Thanks Karl, but I want to avoid to do it in the macro script.

Is it possible to do it like a variable?

I mean, you can set a variable like v = GetActiveSheetId() and this would return the id of the variable. And I want exactly the same to get the Name of the sheet.

Is that possible?

Many thanks anyway

[pover]

Not that I know of. It would be much easier to do the reverse and put in the sheet name field a variable.

Regards.

[marcel_olmo]

Ok Karl. Many thanks anyway