Help with lisp related to VBA

I have three vba apps that I'm loading with a lsp routine

An example of one of the routines follows:

(defun c:ll()
(vl-cmdf"-vbarun" "LabelLeader.dvb!leader.leaderdraw")
(vl-cmdf"vbaunload" "LabelLeader.dvb")
(princ)
)

for some reason, two of the vba macros fail to unload after executing, both
of these have code only in the module. No user forms or calls outside of
the module.

The third one unloads exactly as desired, but that does have user forms.

Is there some reason why just having all code in the module would prevent
the macro from unloading when given the vbaunload command?

 

Make sure you sell all objects to Nothing. Otherwise it will fail to unload.

You could also try ' Application.UnloadDVB "c:\Path\to\LabelLeader.dvb" '
at the end of the leaderdraw sub.

Tim Riley

 

thank you.. that worked wonderfully, I never thought of doing in that
manner.