Macro not working anymore!

[jriseborough]

We have a add on program for Autocad, and part of it is running a macro at startup. All of a sudden the macro in a DVB file does not run, but the macro is there. I am programming illiterate, and not sure what to do.

Here is the error:

Command: _-vbaload Initializing VBA System...
Open VBA Project: "C:/Program Files/Con Span Utility/Con Span Utility 1_0.dvb"

Command: _-vbarun
Macro name: AcadStartup
Execution error
Command: filedia

Enter new value for FILEDIA <0>: 1

Not sure what to even do.

I have added the dvb file, you will have to change the extension back to dvb, would not let me upload it.

[jriseborough]

We have a add on program for Autocad, and part of it is running a macro at startup. All of a sudden the macro in a DVB file does not run, but the macro is there. I am programming illiterate, and not sure what to do.

Here is the error:

Command: _-vbaload Initializing VBA System...
Open VBA Project: "C:/Program Files/Con Span Utility/Con Span Utility 1_0.dvb"

Command: _-vbarun
Macro name: AcadStartup
Execution error
Command: filedia

Enter new value for FILEDIA <0>: 1

Not sure what to even do.

I have added the dvb file, you will have to change the extension back to dvb, would not let me upload it.

[Alfred.NESWADBA]

Hi,

>> All of a sudden the macro in a DVB file does not run

What changed on your system that made this DVB defect?

From your DVB file there are 2 references to "Con/Span utility and Cande ActivX dll 1.0" and "Autodesk GeAuto 2.0 Type Library"

The second one looks like to be part of AutoCAD Mechanical (not sure, just from searching in www and seeing that the reference to GeAuto is mentioned together with AutoCAD Mechanical) are you sure you are running your AutoCAD with the profile of AutoCAD Mechanical? Are the mechanical commands available?

The "Con/Span utility" is completly unkown to me, do you have any information about that?

As I asked you in the other post (in the AutoCAD thread) ... have you asked the vendor of that DVB?

- alfred -

[jriseborough]

This was a inhouse program written to run in autocad to make life easier for one of our design programs.

Con/span utility is a lisp file that loads a menu into the menu bar, so you can use all the files in the DVB file.

The error I get is attached when running it.

[Alfred.NESWADBA · Accepted solution]

Hi,

>> This was a inhouse program written to run in autocad

To be more specific: it's a tool to run in AutoCAD Mechanical, it can't run in plain AutoCAD (or in a profile that does not load/activate the Mechanical functions).

According to my question before: have you verified that you are running the Mechanical profile?

>> Con/span utility is a lisp file

It may have some parts in LISP, but what I can see from this DVB it looks like needing an ActiveX component (which can't be a LISP) and it has a lot of code in the DVB, so the code is VBA, at least the part you have shown. What makes you sure that this tool is a LISP tool?

May I also reapeat my question: what changed to your system since the tool worked well? When did it start the last time ok and what happend in the meantime to your os, to your workstation, ...?

The message you have shown in the screenshot (classfactory cannot supply requested class) is more Microsoft specific than an AutoCAD issue.

- alfred -

[jriseborough · Accepted solution]

ok, well more I look into the installation, there is a con span utlitly menu file that loads the menu, not a lisp. The DVB is the file that runs the macros for the items in the menu. There is a conspanutility.dll file. Not sure how that gets processed.

my computer was updated with a few items, one was office related, so that might have changed VBA stuff.

This works in mechanical or regualar ACAD, i have tried both.

I think its a VBA isssue. I unistalled the last office update and will try it again.

[jriseborough · Accepted solution]

Ok, it was the office update. I re registered my conspanutility.dll and all is well now.

Thanks

[Alfred.NESWADBA]

Hi,

If that tool is developed in your company don't you have anyone that has to do with the development of that?

>> There is a conspanutility.dll file. Not sure how that gets processed.

That seems to be an ActiveX component, once registered to your system it can be processed from applications like your DVB project.

>> This works in mechanical or regualar ACAD, i have tried both.

You have tried it now? And it was working now?

...ok, in the meantime I saw you got it running after uninstalling something from Office, so my congratulations for that.

But just to keep in mind, if it's an in-house created tool get someone that is responsible for the development. The time will come when you change to 64bit and then you need the next update, so you need someone to modify the code.

Have a nice day, - alfred -

[jriseborough]

Thanks,

We have some developers, but they dont like to touch this, its from 1990's I believe.

We are stuck with 32 bit, the program we use does not work in 64 bit, so all our computers are still 32 bit. Its sucks, but its what we have.