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


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"waveracerr " wrote in 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/