Pasting text into Excel using Selenium

As I said in the comments, Selenium can use SendKeys for this. However, if you should really need the copy-paste action, I suggest using the Clipboard instead.

Please note this needs the Microsoft Forms 2.0 Object Library to be checked in your references. If this is not appearing, add a UserForm to your file, and it will appear as checked by default.

The following subroutine will put a string of text into your clipboard. Executing Ctrl-V after running this will emulate a pasting action.

Sub Boom()
Dim DataObj As MSForms.DataObject
Set DataObj = New MSForms.DataObject
With DataObj
    .SetText "Answer"
    .PutInClipboard
End With
End Sub

Just replace "Answer" with whatever value you want. Better yet, modify the above to be able to take in text strings like below:

Sub Boom(Str As String)
Dim DataObj As MSForms.DataObject
Set DataObj = New MSForms.DataObject
With DataObj
    .SetText Str
    .PutInClipboard
End With
End Sub

Now you can do Boom("Answer") on it and it will put "Answer" to the Clipboard. You can then paste it using Range("A1").PasteSpecial xlPasteAll or whatever.

Hope this can help you out. Not really the Selenium path but at least it's a very clean option. :)

EDIT: To use Selenium's SendKeys, it goes something like:

Sub CopyTest()

Dim Sel As New SeleniumWrapper.WebDriver
Dim keys As New SeleniumWrapper.keys

Sel.SendKeys keys.Control & "c"

End Sub

Hope that helps. :)