This should surely be a very simple one! Either "not possible" or "yes, in one line of code..."
I maintain a number of VBA projects in Excel.
I have a release procedure in each i.e. to copy the Dev Workbook over to UAT before copying to Live.
I would love to have one line in the release macro that says (in pseudocode)
If ThisWorkbook.VBACompiles() Then
The closest I can get is
but seems this is legacy or even spurious functionality because the online help says it
"Causes the current project to be written as a DLL. The DLL name is specified by the BuildFileName property."
I'm not trying to create a DLL.
All I want to do is replicate the VB Editor Debug menu's Compile
command (which is really just a syntax checker) programmatically and confirm all is well before releasing the update.
Anyone out there know how to do this?