Making VBA programs run by Hot Keys or menus

[muck]

Is it possable to make a VBA Program start running using a menu pick or a hot

key. What is the easyest way to make a VBA program pop up in AutoCAD 2010

Thank you,

[BIGAL]

Here is a code example just put it in your autoload file

 

(defun C:vbadrn ()

(vl-vbaload "S:/AutoDESK/VBA/vbadrains.dvb")

(vl-vbarun "pitscheduleupdate")

)

 

you can either type vbadrn or assign it to a menu ^c^cvbadrn or again in the menu ^c^c(vl-vbaload S:/AutoDESK/VBA/vbadrains.dvb") (vl-vbarun "pitscheduleupdate")

[muck]

What autoload file should this routine go into. Acad.lsp ?

Should a make a new autoload File?

 

Thank you,

[muck]

what is (vl-vbarun "pitscheduleupdate") all about? Where did pitscheduleupdate

come form?

[BIGAL]

I guess by your question that your running a VBA that some else has written, to answer though the question there is two steps.

 

1 Load a VBA program it can contain many different routines within it. "VBDRAINS.dvb"

 

2 Run a particular sub routine within the VBA program "pitschedule"

 

If your VBA is already loaded as part of your statrtup proceedure then you only need step2 to run.