View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Check for Complie Error in VBA code via VBIDE

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


"ExcelMonkey" wrote in message
...
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