Extract workbook name within a macro

[waveracerr]

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

 

[Guest]

reply: Try saving the name to a variable

dim x as string
x= activesheet.name

 

[Rob van Gelder]

You can use ThisWorkbook.Path & Application.PathSeparator &
ThisWorkbook.Name