TheSwamp
Code Red => VB(A) => Topic started by: Keith™ on February 09, 2018, 03:33:05 PM
-
I have several VBA utilities that have been around for many years, suddenly they will not load.
The last time I was able to successfully load AutoCAD without errors was on December 21, 2017.
I've uninstalled and re-installed and that hasn't resolved the issue.
Using A2k7 on Win10 x64 not that it should make a difference.
I can load any dvb that does not have userforms. If I try to add a userform, the error comes up "Component not correctly registered".
I've tried to register FM20.dll and it succeeds, but doesn't resolve the issue.
This is limited to AutoCAD. Excel works without issue.
Any ideas?
-
Just a guess, since I don't have the same setup as you...
Could it be that acad 2007 is running vba 6 and xl is running vba 7?
-
Maybe .. I am also using Office 2007 though.
This only started happening around Christmas so I think it has something to so with an update of some kind.
I remember several years ago that upgrading from IE6 to IE7 killed a whole bunch of Excel macros ... I tested it on a system and found that to be the case. I'm wondering what kind of update killed the forms in VBA 6
I have Visual Studio VB6 installed and it uses the VB6 libraries ... on a hunch I just fired it up and it will not load any of the projects.
-
I'm not sure what valid options you might have. Things that vb6 relies on are probably things related to XP. You might try compatibility mode for vs6 and reinstalling vb6 enabler for 2007 (if you can still get it).
-
<thinking out loud>
If you have an older setup that will successfully load / run your old vb proggies you can export each form to a .frm file which is simple text.
You can then compare (e.g. ProgIDs) to forms exported by current VBA, abuse the originals to suit, then import into a new VBA project.
</thinking out loud>
-
VBA enabler for 2007 is no longer available. That being said, vba still works in 2007, just not forms.
I do have another machine that I can use to export the files, but the problem is deeper than that because I can't even create a new form.
-
...the problem is deeper than that ...
Indeed. I'm a digital pack rat but the oldest vba enabler I have is for 2011. Flowers sent.
-
:idea: My field laptop is running 2009 on Win 8.1. My forms are still working so i haven't suffered the same fate. If i can help let me know.
-
I think that Win10 is the culprit.
-
Is Microsoft Forms 2.0 still checked in the references using the Autocad VBAIDE?
-
yes the reference is still checked and vb6 IS installed. It was working on Win10 until sometime in January.
-
Yeah, something has to have changed ... I can't plot to anything except a windows printer and I can't edit the plotter configuration files.
It may be time to wipe and re-install from scratch.
-
If it's working in Excel but not in AC2007 are the two references the same? Could you have two versions of the file in different locations?
-
Hi folks.
Did the original poster ever have any solution?
I have a user who has the exact same issue after a recent MS Office 365 update.
Our updates are 6 months behind general release so that would have been around October 2018.
Another person online reported the same problem last October.
https://answers.microsoft.com/en-us/msoffice/forum/all/microsoft-vba-component-not-correctly-registered/9fbaf700-ed7d-40b7-84cd-e40a987fe831
Can't open an add-in in Excel if it contains UserForms. Can't add a userform herself. Same errors.
We've completely removed & reinstalled Office to no avail. Re-registered FM20.DLL. She's unable to work so I'm trying to help her out.
-
My problem was recently solved by changing the installation of the product. After uninstalling everything I reinstalled as a regular user and no longer run it as an admin. Apparently the change in Window had something to do with the registry but I can’t say for sure. Autocad no longer requires elevation to work. Also, all of the VBA stuff works as it should.
Previously it would only run as an elevated app and that caused other issues that are happily resolved as well.