reply: Try saving the name to a variable

dim x as string
x= activesheet.name


-----Original Message-----
I need to extract a workbook name within a macro.
Ultimately I need the
ability to have the name as a string value within my
macro to use to
paste portions of the name within a cell. I have various
macros that
will extract the filename, etc. but I need the ability to
have the
filename as a string. Any idea on the code required for
this action?
Thanks!


---
Message posted from http://www.ExcelForum.com/

.