_Ending a VBA-program nicely...

[serge]

I have an icon who's starting a VBA-program, behind the icon there is e.g. ^C^C^P(COMMAND "VBARUN" "MyVBAProg")... When I trigger somwhere in my VBA-program the END-statement, I get a 'Execution errornil'-message in the Command-line ... how can I avoid this ? ... Thanks ... SMD

[Anonymous]

End will stop your program, yes, but right at that
point, if you have code in your .Terminate event, of your form to end cleanly,
then it's not executed.

So if you have a form close it first, otherwise I
think I would need some code examples.

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"smd" <serge@devidts.com> a
écrit dans le message de news:
href="mailto:f0cb677.-1@WebX.maYIadrTaRb">f0cb677.-1@WebX.maYIadrTaRb...

I
have an icon who's starting a VBA-program, behind the icon there is e.g.
^C^C^P(COMMAND "VBARUN" "MyVBAProg")... When I trigger somwhere in my
VBA-program the END-statement, I get a 'Execution errornil'-message in the
Command-line ... how can I avoid this ? ... Thanks ...
SMD

[Anonymous]

SMD,

The problem is that when a lisp function ends it will always return nil. So to fix your problem, you should wrap you lisp in a defun

(defun c:myvbaprog ()
(vl-vbarun "MyVBAProg")
(princ)
)

Then in your icon use ^c^cmyvbaprog;

Kilo

[Anonymous]

Unload Me?

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"smd" <serge@devidts.com>
wrote in message
href="news:f0cb677.-1@WebX.maYIadrTaRb">news:f0cb677.-1@WebX.maYIadrTaRb...

I
have an icon who's starting a VBA-program, behind the icon there is e.g.
^C^C^P(COMMAND "VBARUN" "MyVBAProg")... When I trigger somwhere in my
VBA-program the END-statement, I get a 'Execution errornil'-message in the
Command-line ... how can I avoid this ? ... Thanks ...
SMD

[serge]

Works 100%, thanks !

[Anonymous]

Also, it would be better to use the Exit Sub/Function
statement instead of just End.

--
R. Robert Bell, MCSE

href="http://www.AcadX.com">www.AcadX.com

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"smd" <serge@devidts.com>
wrote in message
href="news:f0cb677.-1@WebX.maYIadrTaRb">news:f0cb677.-1@WebX.maYIadrTaRb...

I
have an icon who's starting a VBA-program, behind the icon there is e.g.
^C^C^P(COMMAND "VBARUN" "MyVBAProg")... When I trigger somwhere in my
VBA-program the END-statement, I get a 'Execution errornil'-message in the
Command-line ... how can I avoid this ? ... Thanks ...
SMD