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?
我想使用这个库来处理剪贴板。我希望在下面的屏幕截图中看到它，但我在参考库列表中找不到它。我尝试将VBA表单添加到我的excel项目中但没有成功。我怎样才能让它出现？
I have no FM20.DLL file on my entire computer W7 and Excel 2016.
我的整个计算机W7和Excel 2016上没有FM20.DLL文件。
5 个解决方案
#1
1
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:
从这个旧的知识库文章我猜这个DLL可能只包含在旧版本的Office中？这部分似乎很有希望：
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
作为让最终用户安装Microsoft Office的替代方法，您可以让他们免费下载并安装Microsoft ActiveX控制面板，它还会安装Fm20.dll。有关详细信息，请参阅以下Microsoft Developer Network（MSDN）网站：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).
但是，由于链接工具是从1997开始的，因此您需要在“兼容模式”下运行其设置，方法是右键单击可执行文件并选择“属性”，然后单击“兼容性”选项卡并选择“Windows 95”。 “在兼容模式下运行此程序：”下拉列表。然后以管理员身份运行它（这对我来说使用Windows 8.1）。
#2
6
On 64-bit machines, FM20.dll is in the C:\Windows\sysWOW64 directory. It's 32 bit.
在64位计算机上，FM20.dll位于C：\ Windows \ sysWOW64目录中。这是32位。
#3
1
I found FM20.DLL in C:\Program Files (x86)\Microsoft Office\root\VFS\SystemX86; that's with MS Office 2016 and Windows 10.
我在C：\ Program Files（x86）\ Microsoft Office \ root \ VFS \ SystemX86中找到了FM20.DLL;这与MS Office 2016和Windows 10有关。
#4
0
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.
那个图书馆应该真的存在。我刚刚检查了我的Excel 2016安装（32位），它默认存在（只是未选中）。如果没有，我建议你修理你的办公室。
#5
0
Maybe you can try a late binding using the CLSID
也许你可以尝试使用CLSID进行后期绑定
Dim MyDataObj As Object Set MyDataObj = CreateObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
Dim MyDataObj As Object Set MyDataObj = CreateObject（“New：{1C3B4210-F441-11CE-B9EA-00AA006B1A69}”）
or something like that.
或类似的东西。
#1
1
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:
从这个旧的知识库文章我猜这个DLL可能只包含在旧版本的Office中？这部分似乎很有希望：
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
作为让最终用户安装Microsoft Office的替代方法，您可以让他们免费下载并安装Microsoft ActiveX控制面板，它还会安装Fm20.dll。有关详细信息，请参阅以下Microsoft Developer Network（MSDN）网站：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).
但是，由于链接工具是从1997开始的，因此您需要在“兼容模式”下运行其设置，方法是右键单击可执行文件并选择“属性”，然后单击“兼容性”选项卡并选择“Windows 95”。 “在兼容模式下运行此程序：”下拉列表。然后以管理员身份运行它（这对我来说使用Windows 8.1）。
#2
6
On 64-bit machines, FM20.dll is in the C:\Windows\sysWOW64 directory. It's 32 bit.
在64位计算机上，FM20.dll位于C：\ Windows \ sysWOW64目录中。这是32位。
#3
1
I found FM20.DLL in C:\Program Files (x86)\Microsoft Office\root\VFS\SystemX86; that's with MS Office 2016 and Windows 10.
我在C：\ Program Files（x86）\ Microsoft Office \ root \ VFS \ SystemX86中找到了FM20.DLL;这与MS Office 2016和Windows 10有关。
#4
0
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.
那个图书馆应该真的存在。我刚刚检查了我的Excel 2016安装（32位），它默认存在（只是未选中）。如果没有，我建议你修理你的办公室。
#5
0
Maybe you can try a late binding using the CLSID
也许你可以尝试使用CLSID进行后期绑定
Dim MyDataObj As Object Set MyDataObj = CreateObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
Dim MyDataObj As Object Set MyDataObj = CreateObject（“New：{1C3B4210-F441-11CE-B9EA-00AA006B1A69}”）
or something like that.
或类似的东西。