Saving all clipboard data (text, images & formatting) to a variable

alex100 · #1 09-03-2020, 04:53 AM

To save the clipboard content to a variable, I use this code:

Code:

Dim MyData As DataObject
Dim strClip As String
Set MyData = New DataObject
MyData.GetFromClipboard
strClip = MyData.GetText

The problem is this saves only the text information.

Is there a way to save all clipboard data (text, images, formatting) to a variable?

Then, how could I write the data inside that variable to the document, similar to using the 'Selection.Paste' instruction?

Alex

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to assign the clipboard value to a variable?	fosterpapillon	Word VBA	4	03-06-2017 07:02 PM
ord vba replace the variable text with variable images to make offer products with images	tanzinim	Word VBA	4	12-30-2015 01:40 PM
Formatting imported data into a table with variable record sets	ash6540	Excel	6	03-27-2014 04:13 AM
office 2007 clipboard - options & source formatting	jeffk	Word	3	08-28-2012 02:25 AM
Excel not saving all data and formatting	TRT	Excel	2	04-09-2009 12:51 PM