-
Solved: Substitute Workbook Source Name?
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
my site: www.ecboardco.com
was built w/ a majority of the assistance from the board members here... thanks VBAX.
Just because I see something, doesn't mean that what's actually happening is what I see.
You don't get from 0-90 by standing still!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules