Paste all at a click of all copied texts in clipboard then clear clipboard

[Mehmud Khan]

Hello friends,

good day!

Is there any options to paste all the items at once which I have copied from various sources.

In the below example, I have copied 3 text items and clipboard history show in the bar, there is a button to "Paste All", but I am looking for a vba which paste all inside the cell like below;

before;


after paste;




Also once I clicked on paste then additional VBA would "Clear All" the clipboard history like below;




Thanks in advance.


Regards,
Mehmud

 

[Jon Peltier MVP]

I copied several things (text, ranges, charts) to the Office Clipboard. Then I turned on the Macro Recorder to see what is recorded while I manipulated items on the Office Clipboard.

When I pasted anything, it just recorded ActiveSheet.Paste. Same if I Pasted All. No indication of which clipboard item was pasted.

When I deleted anything from the clipboard, there was nothing recorded. Same with Clear All.

I then looked through the Object Browser and could find nothing that looked like it had anything to do with the Office Clipboard. We can safely say that the Office Clipboard is not exposed to VBA.

 

[Mehmud Khan]

Hi Jon,

Thanks you so much for your valuable time.

Other ninjas and members, any suggestions for above task??

Thanks in advance!!


Regards
-Mehmud

 

[vletm]

Did You check?

copy multiple text in clipboard (outside MS office) then paste all copied items in active cell once

Hello friends! Good day! While working on a project, I need to open and extract data from multiple notepads files. I simple words, my task is; opened notepad 1 _ copied specific line "Payment of 12345 processed" then, opened notepad 2 _ again copied line "Payment of 44567 is pending" then...

chandoo.org