Worksheet name linked to worksheet cell

[Thomas K.]

Hello,

 

is it possible to link the name of the worksheet to a cell inside?

 

If yes: what to put into the cell?

 

Thanks for help.

 

Thomas

[Pat Stanford]

I hope that I am wrong, but I believe the answer is no. I have wanted this functionality for a script I am working on and have not been able to find it.

[MullinRJ]

Hello, @Thomas K., and @Pat Stanford.

   Does this work?

 

=RUNSCRIPT('GetWSName')

where 'GetWSName' is a one line VS:

WSScript_SetResStr(GetName(GetTopVisibleWS));
 

   I hope I understand your question correctly.

 

   Pat, if you don't mind me heeding your recent advice, "This is exactly the type of problem that WSScripts were intended to solve."  I think you nailed it.

 

Raymond

 

[Pat Stanford]

I have not actually done the test @MullinRJ, but I don't think that is going to be reliable. GetTopVisibleWS returns a handle to a worksheet that is open for editing. If it is closed but recalculated I don't think it will give the proper result. I will try to test tonight if you don't beat me to it.

 

 

[MullinRJ]

Hey, Pat.

   Pity, there are too may ways to recalculate a WS. You are right, it doesn't work if a WS isn't open for editing and its image gets recalculated. As someone who doesn't use WSs very much, that is not the way I typically work, but I am in the minority in this regard. If there is a way, I hope you find it.

 

Raymond