Hi,

First off, platform info - WinXP Pro2002, Office 2003.

I have a spreadsheet with 288 small pictures in it. When I copy any of the
first 187 picutes to the clipboard, I see a fully rendered image on the
clipboard. Image 188 is only partially rendered. Images 189 and on only
show a small line on the clipboard - the image is not rendered at all.

The problem is that I'm need to get these images into Access. I've created
a form in Access that opens the spreadsheet, goes through the shapes
collection, copies each shape to the clipboard, then pastes the picture to an
OLE Object column bound to the form. This works great up to image 187.
After that point, the images that are pasted into Access are exactly like the
unrendered images I see on the clipboard. However, if I stay in Excel, and
paste an unrendered image from the clipboard, it ends up rendered just fine
on the Excel sheet.

I have several of the spreadsheets I need to import to Access. I get the
exact same problem at picture 188 in every sheet of the 5 I've tried so far.

Does anyone know why this is happening and have any suggestions as to a
solution?

Thanks!

PS - I've tried the open clipboard, empty clipboard, close clipboard routine
to no avail. Even immediately after a reboot, with nothing on the clipboard,
I can open the spreadsheet, select image 189, and when I copy it to the
clipboard, it is unrendered. Then I go to Access, open the table with the
OLE object column and paste, I get the unrendered image. But if I select
any of the first 187 images from the Excel sheet, copy to the clipboard, and
paste into the Access table, it works fine.
I am completely flummoxed. Thanks again!