Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.0k views
in Technique[技术] by (71.8m points)

excel - 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?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...