Force code to compile

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.
 
T

Tom Ogilvy

How about:

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

Guest

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...
 

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

Similar Threads

Flexi Grids not working - Compile Error in Hidden Module 1
Printing userform in landscape on one page only 2
sorting dates 3
Hennessey on Compilers: don't hand craft your code, let the compilerdo it for you better, faster (o 3
Tom Ogilvy, follow up for "coding for footer" 1
Trouble making a report of all Files within a Folder and all Subfolders? 2
Pass a variable from a class module 1
Why Does My Button Code Copy To "General" Object Window From "[My Button Name]" Objec 0

Top