Microsoft Forms2 Object Library

[Anthony George]

Hi Everyone

I know how to put things on to the clipboard, DoCmd.RunCommand acCmdCopy

I just want to view the current contents of the clipboard in access 2003 using vba.

I Found this code whilst searching for a solution:-

Dim DataObj As New MSForms.DataObject
DataObj.GetFromClipboard
MyString = DataObj.GetText

But it needs the Microsoft Forms2 Object Library

This is not in the list of references, does anyone know how to get it?

Or does anyone know how to read the clipboard a different way.

Many Thank's for any help given

Kindest Regards

Tony

 

[Anthony George]

Hi

I've found a solution.

I tried this the other day and it would not work for me.

DoCmd.RunCommand acCmdPaste

I must have added a reference whilst trying to get the other code mentioned above to work.

Oh well it works fine now


Thanks anyway

Tony