YellowLabPro
05-23-2007, 06:21 AM
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?
'WbsName = Application.Inputbox("Enter PO File Name")
WbsName = Application.ActiveWorkbook
thanks,
Doug
Object doesn't support this propery of method.
Is this a valid method to capture workbook name and if so what is incorrect here?
'WbsName = Application.Inputbox("Enter PO File Name")
WbsName = Application.ActiveWorkbook
thanks,
Doug