retreiving multiple pictures from the office clip board

G

Guest

Does anyone know how to use VB or anything else to retreive mutiple pictures
from the office clip board. I am trying to write a macro to to select
images, in sequence from the office clip board and then paste them to their
assigned cells. eg: clip board item 1 to cell a13, clip board item 2 to
cell d13, etc..

all i get is input from the system clip board...which is the last item that
was copied to the clip board..

thanks in advance!
 
K

keepITcool

the office clipboard (and the related taskpane) are not
programmatically accessible. it's controls are NOT exposed to windows
so using Apis is a deadend.

Unless someone finds a way to subclass the Clipboard Change
Notification in a stable manner... But I doubt it.. unless it can be
done via .NET


Imho the office clipboard is a waste of resources, a memory hog, and
will slow your system down. I know some people even recommend to edit
the registry to disable it's capability to collect multiple items...


So my advice is to collect & paste the pictures one by one,
iso via the office clipboard. and as you may have guessed:
disable it.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Jim Feola wrote :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble pasting from clip board 6
Clip Board 4
HOW DO YOU PASTE FROM THE CLIP BOARD? 1
Copy multiple charts to an array? 2
Multiple Select is also automatically copying. 1
Cluttering Clip Board - Excel XP 3
Copying Text to Clip Board Using a Macro 3
Keyboard shortcuts for office clip board? 4

Top