What causes "Invalid advise flags" run-time error in Excel VBA?

Question

I have a Excel macro that generates a this error whenever it gets input of a specific format. Does anyone knows in general what an advise flag is OR where can I find information on this type of error? Thanks

Runtime error -2147221503 (80040001): Automation error, Invalid advise flags

Answer 1

It's part of Microsoft's OLE component. See msdn

This doesn't solve your problem, but maybe you can find more info there.