+ Reply to Thread
Results 1 to 4 of 4

Excel limitation on number of imported image objects?

Hybrid View

iterature Excel limitation on number of... 08-31-2007, 12:00 PM
royUK Have you checked the size of... 08-31-2007, 12:09 PM
iterature Roy, Thanks for... 09-03-2007, 12:32 PM
royUK I don't think there is a... 09-03-2007, 01:30 PM
  1. #1
    Registered User
    Join Date
    12-07-2006
    Posts
    36

    Question Excel limitation on number of imported image objects?

    Hi.
    I've written some code that builds a catalogue with text and pictures.
    The pictures are inserted as objects, by loading them in directly from the hard-drive.

    In the code, I address the objects/images as an array of shapes.
    Each object/image is loaded into the workbook twice - once in one worksheet and once in another.

    The problem is, I want to import a lot of images in this way: approx. 1650 at the moment (with more added in the future.)
    But when the macro gets to the 790th object (or there abouts), it stops and gives a Run-Time error '1004'.
    It says it 'Cannot insert the object.'
    At this point, each image has been loaded twice into the workbook (so the total number of embedded images may be effectively about 1580.)

    Is there some kind of limitation to the number of objects or images that you can load into an Excel workbook?
    This doesn't seem to be the result of my computer running out of memory, as I have tried to run the code on several different laptops (with different amounts of RAM) and the program always stops at about the same point - at approximately the 790th imported image.

    I have also tried running the code on different versions of Excel: both Excel 2003 and Excel 2007.
    The same thing happens in all cases.

    Any help you could give me with this issue would be greatly appreciated.

    Many thanks.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Have you checked the size of the workbook you are creating? I would imagine it is huge.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    12-07-2006
    Posts
    36
    Roy,

    Thanks for responding.

    I haven't actually been able to create the workbook, as the program stalls and gives an error.

    I wouldn't imagine that it is that big though, as the total file-size of the images being embedded is approx. 7Mb in their native .skc format (they are ISIS Draw sketches.)
    But the code has been tested on a number of computers with different amounts of RAM, so I doubt this would be a problem anyway (I think?)

    Do you know if there is any limitation on the number of shapes or images that can be embedded in a workbook?
    Or a limit on the total amount of memory that Excel allocates to embedded images?

    Many thanks.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    I don't think there is a limit to this

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1