Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can't find Microsoft Forms 2.0 Object Library or FM20.DLL

In my Excel 2016 project (Windows 7), I'd like to work with the clipboard:

Dim DataObj As New MSForms.DataObject
DataObj.GetFromClipboard

But I've got this compiler Error at the first line of code:

User-defined type not defined

So I would like to add the reference to the Microsoft Forms 2.0 Object Library but I have no FM20.DLL file on my entire computer (I have searched through explore and find with cygwin).

I expect to see it as in the screenshot below, but I can't find it.

VBA list of available references

How can I make it appear?

like image 746
Lime Avatar asked Dec 14 '22 08:12

Lime


1 Answers

On 64-bit machines, FM20.dll is in the C:\Windows\sysWOW64 directory. It's 32 bit.

like image 68
jules3766 Avatar answered Jan 19 '23 00:01

jules3766