Force code to compile

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Once a long time ago, Tom Ogilvy passed a short code to me that would
essentially simulate a click of the [Compile VBAProject] button in the VBE.
The objective is to force the code in the current module to (re)compile.

I didn't have any luck searching for it. Could someone (if not Tom) please
post this code again? Thanks.
 
How about:

thisworkbook.VBProject.VBE.CommandBars("Menu Bar"). _
controls("Debug").Controls("Compi&le VBAProject").Execute
 
That's the one! Thanks again Tom.

Tom Ogilvy said:
How about:

thisworkbook.VBProject.VBE.CommandBars("Menu Bar"). _
controls("Debug").Controls("Compi&le VBAProject").Execute

--
Regards,
Tom Ogilvy


quartz said:
Once a long time ago, Tom Ogilvy passed a short code to me that would
essentially simulate a click of the [Compile VBAProject] button in the VBE.
The objective is to force the code in the current module to (re)compile.

I didn't have any luck searching for it. Could someone (if not Tom) please
post this code again? Thanks.
Click to expand...
Click to expand...
 
Back
Top