PDA

View Full Version : [SOLVED] Forms 2.0 library



vegard
01-04-2017, 04:55 AM
Hi folks. I've just installed the newest version of Office 365. Now I'm trying to find the Microsofts Forms 2.0 library in the VBA reference list, but it's just not there :crying: Any tips on how I fix this, is it possible to download the .dll-file manually and put it somewhere? Or any other tips or hints?

Kenneth Hobs
01-04-2017, 07:25 AM
If used it should be near the top. If not look for it as "Microsoft Forms 2.0 Object Library". If not found, Browse and add it from c:\Windows\SysWow64\FM20.dll.

vegard
01-04-2017, 07:53 AM
Maybe we have identified the problem there: A search for this file does not return any results. The library is not available either, through the reference menu in VBA. What to do next? :doh:

Kenneth Hobs
01-04-2017, 07:56 AM
That is for 64bit which I assume that you have? What operating system do you have? Try looking in c:\windows\system32.

vegard
01-04-2017, 08:02 AM
Yes, I have 64 bit. In system32 I have "fmifs.dll" and "fms.dll", but no fm20, unfortunelately. Is it possible to add it there manually, or?

Kenneth Hobs
01-04-2017, 03:36 PM
Sounds like an update did not happen. Try a manual update via Excel > File > Account, or see:
https://support.office.com/en-us/article/Update-history-for-Office-2013-19214f38-85b7-4734-b2f8-a6a598bb0117?ui=en-US&rs=en-US&ad=US

vegard
01-05-2017, 12:36 AM
Thanks for the tip, I've tried to run the update from that menu. It seems I have the highest version of Office. But still no Microsoft Forms 2.0 in the reference list :( May it be that it has some other name?: pray2:

Kenneth Hobs
01-05-2017, 05:38 PM
Try this but I suspect that you may need to contact Microsoft Support.

http://www.cpearson.com/excel/missingreferences.aspx

snb
01-06-2017, 12:29 AM
Download fm20.dll.
Doubleclick and register it and/or put it in the c:\windows\system32(64?) directory.

vegard
01-07-2017, 06:25 AM
Thank you guys for all the input, it helped me a lot towards finding it out. Just to help others who finds this thread with the same problem as me, this is how I solved it:

- I downloaded the Fm20.dll from Originaldll dot com
- I pasted the Fm20.dll file in the same folder as Excel is installed.
- In the list of libraries in the VBA Editor i browsed for the file an added it (see the attached picture).
- After picking the fm20.dll file, the library named "Microsoft Forms 2.0" popped up.

As many tried to tell me above, very basic. But why I did not make it work at first was that I believed (falsely) that adding the file to the directory was enough alone. It was the "manual" approach I did not realize was necessary.

But now everything works, and I can run code with Forms 2.0 Library again. So again folks; thanks a lot. I'm not new to this forum (but had to make a new account after changing email adress) and just have to say: I just love VBA Express. It makes my professional life so much easier. Thanks!