Create a Command to run macro from command line

Hi,

I need to create a command where you type MP in the command line and this will call the VBA macro "MakeP".

how you make this in Autolisp?

I guess the command name is called : -vbarun

(defun c:mp ()
(command "-vbarun")
 )

But this is not a recommend way.although you can use the (acad.pgp)

to change command abbreviations as best as you want.

Tharwat

Hi,

I need to create a command where you type MP in the command line and this will call the VBA macro "MakeP".

how you make this in Autolisp?

Take a look at http://www.afralisp.net/visual-lisp/tutorials/loading-vba-files.php

But this is not a recommend way.although you can use the (acad.pgp)

to change command abbreviations as best as you want.

If writing a full defun, I would suggest adding a load statement within ACADDOC.lsp. :wink:

I do not use VBA often, but I believe this is the correct syntax to load and execute the command (please correct me where I am wrong):

(defun c:MP ()
 (if (not [color=black]MakeP[/color])
   (command "._vbaload" "[color=red]vbaCommand[/color].dvb"))
 (command "._-vbarun" "MakeP")
 (princ))

If writing a full defun, I would suggest adding a load statement within ACADDOC.lsp. :wink:

 

I do not use VBA often, but I believe this is the correct syntax to load and execute the command (please correct me where I am wrong):

Absolutely Correct.

Actually I couldn't try it, because in Autocad version 2010 is not supported anymore.

Thanks a lot.

Tharwat

Thanks a lot.

You're welcome.

Thank you all for the solution. Works fine.

The vba is still supported by AutoCAD 2010, but you need to download tha application from Aotudesk web page

Thank you for the favor back.

Best regards

Tharwat