Using IE to seed the clipboard

[Weaver]

I had a bit of vbs code that seeded certain strings into the clipboard

    With CreateObject("internetexplorer.application")
        .navigate ("about:blank")
        .document.parentwindow.clipboarddata.SetData "text", a
        .Quit
    End With

I need to use this in excel but as it currently stands, it issues an alert "Do you want this webpage to access your clipboard". Can I override this? Or is there a better way to achieve the same result?

 

[RoryA]

It late binds the MSForms.DataObject. I don't think you can use that in VBS, but I might be wrong.

 

[Weaver]

Am I right in thinking late binding is used to remove the need to register references?

 

[RoryA]

Yes. If you set a reference to the MSForms library then you just Set ... = New MSForms.DataObject instead.