Application.run

[Roderick_E]

I'm running subroutines from another subroutine by using Application.run <string> such as Application.run testmacro
The problem is, there is no error if the macro doesn't actually exist. I could just as well add Application.run thisisbogus and it would appear to do something even though it isn't. How can I put in error trapping? Thanks

 

[Kenneth Hobson]

I don't know what you mean. It errors at Compile if you use a variable as you did. If you use a string as I did, it errors at runtime.

Sub test()
  On Error GoTo msg
  Application.Run "ken"
  Exit Sub
msg:
  MsgBox Err.Number & vbLf & Err.Description
End Sub

 

[Roderick_E]

whooops I have on error resume next for other stuff so it probably isn't trapping there. Thanks for prompting me on that.