[SOLVED] Trouble with module wide variable

Good morning saabman

Originally Posted by saabman

I am trying to get a module wide variable to provide the current filename to the various subs...

It seems I can't say the "CurrentFileName" be a cell value.
why is this? I used the =CELL("fileneme") in the cell which I then gave a name to "sFileName". I get get the value if I declare the variable in the sub but not if it is declared at the beginning of the module...

You don't have to get the file name from a cell - you can just pick it straight up from VBA. Whether you use the .Name command or .FullName command depends on whether you want to see just the filename or the full path :

MsgBox ThisWorkbook.Name
MsgBox ThisWorkbook.FullName

HTH

DominicB