Extract workbook name within a macro

  • Thread starter Thread starter waveracerr
  • Start date Start date
W

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
 
Back
Top