Solved: Substitute Workbook Source Name?

[YellowLabPro]

I wanted to swithc the way I capture the workbook source name from an input box entry to the active workbook. But this line returns error 438
Object doesn't support this propery of method.
Is this a valid method to capture workbook name and if so what is incorrect here?

[VBA]
'WbsName = Application.Inputbox("Enter PO File Name")
WbsName = Application.ActiveWorkbook
[/VBA]

thanks,

Doug

[mvidas]

Good morning Doug,

[vba]WbsName = Application.ActiveWorkbook.Name[/vba]
Or just
[vba]WbsName = ActiveWorkbook.Name[/vba]


Matt

[YellowLabPro]

Hi Matt,
Thanks.... Darn it.... thought I had that one....

[mvidas]

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)