Capturing Workbook Name

[Pablo_TX]

I need to be able to capture the a workbook's name and then use it within the macro.