Cannot find Microsoft Forms 2.0 Object Library or FM20.DLL

Question

I would like to use this library to work with the clipboard. I expect to see it as in the screenshot below, but I can not find it in the list of reference libraries. I tried adding a VBA form to my excel project without success. How can I do it?

I do not have the FM20.DLL file on my W7 and Excel 2016 computer.

Answer 1

From this old knowledge base article . I think this DLL is probably only included in older versions of Office? This piece seemed promising:

As an alternative to having end users install Microsoft Office, you can freely download and install the Microsoft ActiveX Control Pad, which also installs Fm20.dll. For more information, see the following Microsoft Developer Network (MSDN) Web site: http://msdn.microsoft.com/en-us/library/ms968493.aspx

However, since the associated tool is from 1997, you will need to start its configuration in "compatibility mode" by right-clicking on the executable file and selecting "Properties", then clicking on the "Compatibility" tab and selecting "Windows 95" in the "Run" section This program is in compatibility mode for: "Drop-down menu. Then run it as an administrator (this worked for me using Windows 8.1).

Answer 2

On 64-bit machines, FM20.dll is located in the C:\Windows\sysWOW64 . He is 32 bit.

Answer 3

I found FM20.DLL in C: \ Program Files (x86) \ Microsoft Office \ root \ VFS \ SystemX86; this is with MS Office 2016 and Windows 10.

Answer 4

This library really should be there. I just checked the installation of Excel 2016 (32 bit) and it is by default (just not checked). I recommend repairing your office if it is not there.

Answer 5

Perhaps you can try the latest binding using the CLSID

Dim MyDataObj As Object Set MyDataObj = CreateObject ("Create: {1C3B4210-F441-11CE-B9EA-00AA006B1A69}")

or something like that.