Microsoft KB Archive/928983

From BetaArchive Wiki
Knowledge Base

Error message when you run a VBA macro that uses the "Insert" method or the "AddPicture" method to insert a picture in Excel 2007: "Application-defined or object-defined error"

Article ID: 928983

Article Last Modified on 10/15/2007


  • Microsoft Office Excel 2007


You run a Microsoft Visual Basic for Applications (VBA) macro that uses the Insert method or the AddPicture method to insert a picture in a worksheet in Microsoft Office Excel 2007. When you do this, the picture is not inserted. Additionally, you receive the following error message:

Run-time error '1004':

Application-defined or object-defined error


This issue may occur if the picture is located in an HTTP location.


To work around this issue, code the VBA macro to insert the picture as a picture fill in a shape such as a rectangle.

Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12

Keywords: kberrmsg kbtshoot kbmacro kbprogramming kbautomation kbprb kbgraphic kbvba kbexpertisebeginner KB928983