I need to try and Paste all items saved on the clipboard into excel using VBA.
I currently have a code that does half the job, i.e it only pastes the last copied item on the clipboard but I need it to paste all items on the clipboard.
Note: this code only works when I select Tools> references and checking the box for Microsoft Forms 2.0 Object library.
'--------------beginning of code
Public Function GetOffClipboard() As Variant
Dim MyDataObj As New DataObject
GetOffClipboard = MyDataObj.GetText()
'-----------end of code
Again my question is: I need to paste all item on the clipboard to excel using VBA coding.
Thanks in advance.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…