topic Re: VBA macro won't load from CUI in VBA Forum

VBA macro won't load from CUI

Anonymous — Wed, 09 Jan 2019 19:48:38 GMT

This macro used to work when clicked from the the AutoCAD menubar. But now it fails. Any idea on how to get it back to working?

^C^C-vbarun (strcat vbapath "ChangeLayerCase.dvb!Module1.LyrChgCase")

Command: -vbarun
Macro name: (strcat vbapath "ChangeLayerCase.dvb!Module1.LyrChgCase") "F:\\AC2018\\vba 64 bit\\ChangeLayerCase.dvb!Module1.LyrChgCase"

Macro name:

Re: VBA macro won't load from CUI

Ed__Jobe — Fri, 11 Jan 2019 15:54:45 GMT

Can you load the file using VBAMAN? Can you then run the macro using VBARUN (not the command line verstion)? If so, check to make sure that the file, module and macro have not been renamed.

Re: VBA macro won't load from CUI

Anonymous — Fri, 11 Jan 2019 16:07:41 GMT

Yes, I can run everything from the command line.

However, I'd rather just click the menu item.

Adding the macro to the end of the command script works though.

^C^C-vbarun (strcat vbapath "ChangeLayerCase.dvb!Module1.LyrChgCase") lyrchgcase

Re: VBA macro won't load from CUI

Ed__Jobe — Fri, 11 Jan 2019 16:15:04 GMT

That's redundant. That means that the first call is loading the file, but the macro can't be found. The second attempt succeeds because the macro is now loaded. Are you sure that Module1 hasn't been renamed?

Re: VBA macro won't load from CUI

Anonymous — Fri, 11 Jan 2019 16:46:21 GMT

As I said, it used to work, but something changed in the 2017 or 2018 versions. Adding the macro call made it work again.

Re: VBA macro won't load from CUI

Ed__Jobe — Fri, 11 Jan 2019 16:51:34 GMT

Don't you want to figure out why? Your workaround doesn't fix the original problem. It shouldn't be necessary to enter the macro name twice.

edit: The png shows that the folder name was changed to AC2019.

Re: VBA macro won't load from CUI

Anonymous — Fri, 11 Jan 2019 22:38:50 GMT

^C^C-vbarun (strcat vbapath "ChangeLayerCase.dvb!Module1.LyrChgCase")

The vbapath variable contains the correct path to the folder. It depends on what version of AutoCAD you are using. Yesterday, I was running 2018, today I'm running 2019. Both versions have the same files.

Have you tried using the command string in a menu item or are you assuming? I have tried and it doesn't work without calling the macro function after the -VBARUN command.

Re: VBA macro won't load from CUI

Ed__Jobe — Fri, 11 Jan 2019 23:04:04 GMT

Been doing this since vba was first introduced. You never need to enter the method name twice. If you do, it's becasue the first call couldn't find it. Here is an example from the help file on the proper syntax:

Acad_Projects.dvb!Project1.Module1.Test

Oops, I just noticed that you didn't include the project name when you created the menu macro for the new version of acad. You only specify Module1 and the method name. Look in the Project Explorer (Ctrl+R) to find the project name. The default is "AcadProject".

Re: VBA macro won't load from CUI

Anonymous — Fri, 11 Jan 2019 22:59:33 GMT

Here's the screenshot of the dialog based VBARUN command. The macro works when I click the Run button. Note the name of the macro, it's the same as the one I'm using. So I'm not sure what you mean by "you didn't include the project name".

Re: VBA macro won't load from CUI

Ed__Jobe — Fri, 11 Jan 2019 23:02:26 GMT

I was editing my last post when you posted yours. Please reread it.

Re: VBA macro won't load from CUI

Ed__Jobe — Fri, 11 Jan 2019 23:07:12 GMT

The VBAMAN also shows the project name along with the file/dvb.

Re: VBA macro won't load from CUI

Ed__Jobe — Fri, 25 Jan 2019 15:30:58 GMT

@Anonymous Did you get this problem solved correctly? If my answer solved your problem, please accept it as the solution.

Re: VBA macro won't load from CUI

Anonymous — Thu, 28 Mar 2019 20:20:50 GMT

Finally found the problem, I need two spaces (or returns) before the -vbarun and a space after lyrchgcase, indicated by the underscores below. For some reason, -vbaload need two returns after you enter the project name. And the return after the lyrchgcase completes the command.

-vbaload (strcat vbapath "ChangeLayerCase.dvb!Module1.LyrChgCase")__-vbarun lyrchgcase_