VBA-Excel: Storing multiple data In the Windows Clipboard

In earlier sessions  you saw how to put text in the windows clipboard (Putting Text In The Windows Clipboard) with the help of PutInClipboard() and Data Object and how to get the text from the Clipboard using GetFromClipboard() and Data Object.

In this session you will learn how to store multiple data’s in Clipboard and retrieve them. For storing multiple data’s, you need to store values as pair, Keys and Values or you can say format identifier and while retrieving the data from the Clipboard you will use these format identifiers to get the data. This data can be String, Long, Integer.

For storing multiple data in Clipboard, Follow the below steps.

Read more

VBA-Excel: Get Text from the Windows Clipboard

In earlier session you saw how to put text in the windows clipboard(Putting Text In The Windows Clipboard) using PutInClipboard() and Data Object. In this session you will learn how to get the text from the clipboard.

For Getting the text from the Clipboard, Follow the below steps.

Steps:

  •         Initialize the Data Object, the type of MSForms.DataObject
  •         Get the text from the clipboard using Data Object
  •         Get the text out of Data Object using GetText() method.

Read more