Excel 2007
I'm suddenly getting a compile error that says,
"Compile Error:"
Object does not source automation events."
I'm not sure why I am suddenly getting this error, because things have been running smoothly until now. Objects that do not have events usually just never listed any events. But now Excel is fussing at me. Can anyone tell me what setting I might have changed? The declaration is made in a class module, so it's not an issue of location.
-Joshua
Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]
I'm suddenly getting a compile error that says,
"Compile Error:"
Object does not source automation events."
I'm not sure why I am suddenly getting this error, because things have been running smoothly until now. Objects that do not have events usually just never listed any events. But now Excel is fussing at me. Can anyone tell me what setting I might have changed? The declaration is made in a class module, so it's not an issue of location.
Code:
Private WithEvents itmsDAItemColl As OPCItems-Joshua
Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]
