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

"John Bundy" wrote:

this will get it ActiveWorkbook.Name
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"geebee" wrote:

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