One of my workbooks won't allow me to use the VBE variable types (VBProject, VBComponent, etc.) They aren't on the popup list that appears when I type " as ". If I just type in "VBProject", I get a compile error "User-defined type not defined". I have to define the variable as object, and the macro still works. I do not have this problem in any other workbook.
Last edited by foxguy; 04-20-2009 at 04:55 PM.
Set a reference to Microsoft Visual Basic for Applications Extensibility
Entia non sunt multiplicanda sine necessitate
Thanks, should have thought of that myself. Do you have any idea how it could have gotten unchecked.
Nary a clue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks