Compile VBAProject under Debug menu in VBA

celltician · Mar 6th, 2002, 03:45 PM

Does it do anything?? I wrote a short VBA program and hit Compile VBAProject. It did something very fast but gave no indication of what it did???
I looked up 'Compile' in help with NO results.

What is it for???

Thank you.

Barrie Davidson · Mar 6th, 2002, 03:53 PM

I believe compiling just checks to verify that your syntax is correct and that there are no obvious errors (DO statement without a LOOP ending, for example).

Regards,

Jack in the UK · Mar 6th, 2002, 04:19 PM

BTW

I use this as Mark says and just help if im miss something also step through in test stages can be cool.

Short scripts are not so painful, 100 lines of complex code and 3 cases doing bits with loops all give agro to the programmer this can help.. I dont use VBA Checker software thats about, no reason just dont..

HTH

Juan Pablo González · Mar 6th, 2002, 06:35 PM

Well, first message in a while, don't know when I'll be back again...

Just to let you know, Compiling projects actually has some effects in the program. Whenever the macro is run, VB compiles the macro to "translate" it into machine code, (Well, something very similar to this). The truth is that a VB Project has three (As far as I remember...) stages, two of them are "P" code and "X" code (This is just by memory from an article I read a while, so, I may be wrong with the letters). When you compile, VB translates from one to the other, which makes it run much faster.

So, in big projects, it's a good idea to compile BEFORE saving, that way the program has ALREADY translated the code, and there's no need to translate it at the beginning, which results in faster loading times. It has no "visible" effect on small programs.

d-alan · Dec 3rd, 2002, 06:43 PM

I find myself with the need of understanding the 'compile vbaproject' option.
As I just executed this and it doubled the size of my workbook. From about 500k to 1.07mb.
Is this normal. Or is there something else?????

Thanks in advance,
-D

Arul.rajesh · Oct 13th, 2011, 03:44 PM

Quote:

Originally Posted by d-alan

I find myself with the need of understanding the 'compile vbaproject' option.
As I just executed this and it doubled the size of my workbook. From about 500k to 1.07mb.
Is this normal. Or is there something else?????

Thanks in advance,
-D

Back from the dead...
Will Compiling speed up the running of the code?

Mar 6th, 2002, 03:53 PM	#2
Barrie Davidson MrExcel MVP Join Date: Feb 2002 Location: Winnipeg Posts: 2,330	I believe compiling just checks to verify that your syntax is correct and that there are no obvious errors (DO statement without a LOOP ending, for example). Regards, __________________ Barrie Davidson "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Mar 6th, 2002, 04:19 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	BTW I use this as Mark says and just help if im miss something also step through in test stages can be cool. Short scripts are not so painful, 100 lines of complex code and 3 cases doing bits with loops all give agro to the programmer this can help.. I dont use VBA Checker software thats about, no reason just dont.. HTH __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Mar 6th, 2002, 06:35 PM	#4
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Well, first message in a while, don't know when I'll be back again... Just to let you know, Compiling projects actually has some effects in the program. Whenever the macro is run, VB compiles the macro to "translate" it into machine code, (Well, something very similar to this). The truth is that a VB Project has three (As far as I remember...) stages, two of them are "P" code and "X" code (This is just by memory from an article I read a while, so, I may be wrong with the letters). When you compile, VB translates from one to the other, which makes it run much faster. So, in big projects, it's a good idea to compile BEFORE saving, that way the program has ALREADY translated the code, and there's no need to translate it at the beginning, which results in faster loading times. It has no "visible" effect on small programs. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 03:45 PM	#1
celltician New Member Join Date: Feb 2002 Location: Wisconsin Posts: 9	Does it do anything?? I wrote a short VBA program and hit Compile VBAProject. It did something very fast but gave no indication of what it did??? I looked up 'Compile' in help with NO results. What is it for??? Thank you.

Dec 3rd, 2002, 06:43 PM	#5
d-alan Board Regular Join Date: Mar 2002 Posts: 119	I find myself with the need of understanding the 'compile vbaproject' option. As I just executed this and it doubled the size of my workbook. From about 500k to 1.07mb. Is this normal. Or is there something else????? Thanks in advance, -D