I think your problem is caused by the "Office Clipboard."

DEselect "Collect without Showing Office Clipboard"
(under options at the bottom of the clipboard task pane)

then hide the pane.

try again.
HTH
--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


MikeT wrote in


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!