I'm wondering if it is possible to selectively paste from the clipboard.
For example, lets say you copy 3 diff cell values to the clipboard.
I would like to have a predefined set of hotkeys ie. ctrl+shift+alt+1 ,
2, 3 that would paste the 1st 3 slots (whatever they are called) from
the clipboard respectively. I can assign the keys, I'm just wondering
how to access the different slots in the clipboard in Office...

Cheers

Job

do this experiment
open the cliboard toolbar (views-toobar)
now one by one copy some three cells (only copy)
these 3 copies will be palced in clipboard toolbar
you can copy any of them or all of them

is this what you want
or as this message is <programme newsgroup do you want a vba solution



Job wrote in message
...
I'm wondering if it is possible to selectively paste from the clipboard.
For example, lets say you copy 3 diff cell values to the clipboard.
I would like to have a predefined set of hotkeys ie. ctrl+shift+alt+1 ,
2, 3 that would paste the 1st 3 slots (whatever they are called) from
the clipboard respectively. I can assign the keys, I'm just wondering
how to access the different slots in the clipboard in Office...

Cheers

Job

R.VENKATARAMAN wrote:
do this experiment
open the cliboard toolbar (views-toobar)
now one by one copy some three cells (only copy)
these 3 copies will be palced in clipboard toolbar
you can copy any of them or all of them

is this what you want
or as this message is <programme newsgroup do you want a vba solution



Job wrote in message
...

I'm wondering if it is possible to selectively paste from the clipboard.
For example, lets say you copy 3 diff cell values to the clipboard.
I would like to have a predefined set of hotkeys ie. ctrl+shift+alt+1 ,
2, 3 that would paste the 1st 3 slots (whatever they are called) from
the clipboard respectively. I can assign the keys, I'm just wondering
how to access the different slots in the clipboard in Office...

Cheers

Job




Yes, I know that you can copy multiple items on the clip board. I want
to, via vba, access the different things captured on the clipboard...

itis possible to use clipboard in vba (see help in vba) i would prefer to
use of variables

variables suppose a,b,c dim them as range
set a=something
set b=something else etc

you want to copy to F1
range("f1")=a
etc.

try something like this
if necessarsy do loops

may not be elegant
not tested.

Job wrote in message
...
R.VENKATARAMAN wrote:
do this experiment
open the cliboard toolbar (views-toobar)
now one by one copy some three cells (only copy)
these 3 copies will be palced in clipboard toolbar
you can copy any of them or all of them

is this what you want
or as this message is <programme newsgroup do you want a vba solution



Job wrote in message
...

I'm wondering if it is possible to selectively paste from the clipboard.
For example, lets say you copy 3 diff cell values to the clipboard.
I would like to have a predefined set of hotkeys ie. ctrl+shift+alt+1 ,
2, 3 that would paste the 1st 3 slots (whatever they are called) from
the clipboard respectively. I can assign the keys, I'm just wondering
how to access the different slots in the clipboard in Office...

Cheers

Job




Yes, I know that you can copy multiple items on the clip board. I want
to, via vba, access the different things captured on the clipboard...

I don't think I'm explaining myself very well. If you copy the values
7,8,9,10 into the clipboard. I want to know how programatically to access
each of the values ie.

Set objCB = New DataObject
objCB.GetFromClipboard
objCB.GetText(1)
objCB.GetText(2)
objCB.GetText(3)
objCB.GetText(4)
Where the 1,2,3,4 are the different slot or elements of the clipboard. I've
read a lot of things that look for text or a specific kind of format that is
on the clipboard, however, I'm interested in being able to reference the
individual elements of the clipboard. It would be the same as seeing the
above values in the clipboard taskpane, and clicking on the 3rd in the list,
or '8' and having that 'paste' into the sheet where ever you choose. As
opposed to clicking the '8', I would like to access that element via vba.

Hopefully this explains more clearly what I'm attempting to do..