Check for Complie Error in VBA code via VBIDE

E

ExcelMonkey

Does the VBIDE provide any methods or properties that detect complie errors
in target code? I realize that a macro to check for a compile error in a
target file would not even start if there was a compile error. But if you
were checking this outside of Excel (say VB.Net or C#) coudl you test a code
module for this in a target file?

Thanks

EM
 
R

RB Smissaert

I think all you can do is in the VBE: Debug, Compile VBAProject....
Don't think it is possible to test say a .bas file from outside Excel.

RBS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top