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't find it in my list of reference libraries. I tried adding VBA form to my excel project with no success. How can I make it appear?
I have no FM20.DLL file on my entire computer W7 and Excel 2016. I have searched both through explore and using find
with cygwin.
From this old knowledge base article my guess would be this DLL is perhaps only included in older versions of Office? This part seemed promising:
As an alternative to having your end users install Microsoft Office,
you can have them freely download and install the Microsoft ActiveX
Control Pad, which also installs the Fm20.dll. For more information,
see the following Microsoft Developer Network (MSDN) Web site:
http://msdn.microsoft.com/en-us/library/ms968493.aspx
However, as the linked tool is from 1997, you'll need to run its setup in "compatibility mode" by right-clicking on the executable and selecting "Properties" then clicking on the "Compatibility" tab and selecting "Windows 95" in the "Run this program in compatibility mode for:" dropdown. Then run it as administrator (this worked for me using Windows 8.1).
On 64-bit machines, FM20.dll is in the C:\Windows\sysWOW64
directory. It's 32 bit.
I found FM20.DLL in C:\Program Files (x86)\Microsoft Office\root\VFS\SystemX86; that's with MS Office 2016 and Windows 10.
Maybe you can try a late binding using the CLSID
Dim MyDataObj As Object
Set MyDataObj = CreateObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
or something like that.
That library should really be there. I just checked on my Excel 2016 installation (32 bit) and it is there by default (just not checked). I recommend to repair your Office if it isn't there.