filename

[Guest]

hi,

i woud like to know how i can get the filename f the actoveworkbook and
store it as a string to be used as a variable.

thanks in advance,
geebee

 

[Guest]

this will get it ActiveWorkbook.Name

 

[Alberto Ast]

this is great and have helped me fix a problem with filenames changed