ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Check for Complie Error in VBA code via VBIDE (https://www.excelbanter.com/excel-programming/434145-check-complie-error-vba-code-via-vbide.html)

ExcelMonkey

Check for Complie Error in VBA code via VBIDE
 
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

RB Smissaert

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




All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com