Set a worksheet cell to the files name?

[Fuge]

Hi Guys...

 

First,  thanks in advance for the help. 

 

Has anyone figured out how to set a worksheet cell to the files name?    There doesn't appear to be a function for worksheets... 

 

You'd think there'd be something simple like...  = GetFName   as in VS.     

 

I'm sure I can figure out something by scripting something to create an Object in the document to read.

 

Cheers! 

Dave

 

 

[Pat Stanford]

There does not appear to be a WS function to do what you want.

 

Try and create a script from the line below and then enter a worksheet formula of:

 

=RunScript('NameYouGaveTheScript)

 

This is the one line script you need.

WSScript_SetResStr(GetFName);

 

[Fuge]

That works great-  thanks Pat... 

 

Dave