Dynamically compile/syntax check another document

[AndyW]

My Visio application opens another visio document that contains code, this then calls methods in this document using callbyname. This all works fine. However, if  the visio document being opened has some compilation errors this then causes my application to stop. Ideally I would like to catch this error at runtime, give a message and then not use the document. Alternatively, is it possible to compile this other document to determine if it contains any errors or syntax check it.

I know ideally there should not be compile time errors, but if for some reason the application has changed but the additional document has not been updated I would like to be able to handle this gracefully.

This is all VBA.

[Visio Guy]

Good question, Andy! I really don't know - VBA can be rather weird sometimes.

Have you tried wrapping the open-other-document code in some sort of error-catching block? I'm not sure if this would trap the compilation error, but it is worth a shot:

Code Select Expand


Sub OpenOtherVbaVisioDoc

  On Error Goto Error_OpenOtherVbaVisioDoc

  ' Open document
  ' Do stuff...

  Exit Sub

Error_OpenOtherVbaVisioDoc:

  Debug.Print "Oh no, a compilation error!"

End Sub

[AndyW]

I tried adding error handling, but it seems I am unable to catch a compilation error.

[Visio Guy]

Yeah, I wasn't sure it would work.

There is an OpenEx flag that allows you to open a document with macros disabled, which might help with the compilation error, but then, well, your macros won't be callable. 

[AndyW]

Using OpenEx with macros disabled on another document is worse than that as it stops the code in the current document as well!

[Visio Guy]

That doesn't sound right or good to me...