Clipboard Limits in Excel?

[MikeT]

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!

 

[keepITcool]

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

 

[MikeT]

Thanks keep! Changing the Office clipboard options didn't affect the outcome
- I'm still getting blank pictures. I was 'off by one' in my earlier post -
the problem begins after the 188th picture, not the 187th. Your suggestion
was helpful though - what I noticed is that I am never able to paste into
Access from the Office clipboard under any circumstance - the option is
greyed out in the office clipboard. The only option is right-click and paste,
which I assume comes from the system clipboard, as I can only paste the last
item copied.

Thanks again,
Mike