an error that says Unable to get the object property for the OLEObject class RRS feed

  • Question

  • Good day

    Our clients are suddenly experiencing a problem when running an excel model we gave them. The model was running very well until recently when they start experiencing error messages that says Unable to get the object property for the OleObject Class. Could you please assist us with a solution so that we can assist our clients.



    Monday, February 23, 2015 8:31 AM

All replies

  • Need a little more info here!! A wide range of things can cause this error message.

    What version and Service Pack level are you and your client running? When I release stuff I always specify a minimum of latest Service Pack has to be installed. No support without it otherwise I end up chasing bugs that are already fixed.

    Get them to click the debug button. We need to know what statement is causing the problem and what the preceding code is.

    Can they go to Tools, References and make sure all references you need are still selected.

    Rod Gill
    Author of the one and only Project VBA Book

    Monday, February 23, 2015 7:47 PM