Another thing you could do, depending on what you need the workbook name for, is to set a workbook variable for the activeworkbook[vba]dim WB as workbook
set wb=activeworkbook[/vba]Then you'd only have to use WB to refer to the active workbook (instead of something like Workbooks(WbsName) which you could be doing)