UnloadDVB rountine

[Anonymous]

I read the post for the best way to exit a VBA routine, but I came up short in my routine. I am running a macro (which has no forms) and would like it to unload itself when it is done. The routine works great except I get that "execution error" when the macro is done running. Is there a way to exit the routine without this error? Currently I am using UnloadDVB "C:\myroutine.dvb" to do the process. Thank you in advance for the assistance.

[Anonymous]

Kent,

Try using

ThisDrawing.SendCommand "_vbaunload" & vbCr & "YourDVB.dvb" & vbCr

Regards,

James


"Kent_H" wrote in message
news:f08f32b.-1@WebX.maYIadrTaRb...
I read the post for the best way to exit a VBA routine, but I came up short
in my routine. I am running a macro (which has no forms) and would like it
to unload itself when it is done. The routine works great except I get that
"execution error" when the macro is done running. Is there a way to exit the
routine without this error? Currently I am using UnloadDVB
"C:\myroutine.dvb" to do the process. Thank you in advance for the
assistance.

[Anonymous]

I have done this method in the passed, but I would like to exit this routine transparently.