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

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