AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Compile Vba Project3/29/2021
For a better experience, please enable JavaScript in your browser before proceeding.It did something very fast but gave no indication of what it did I looked up Compile in help with NO results.
Compile Vba Project Code And 3Short 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. ![]() 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). ![]() So, in big projects, its a good idea to compile BEFORE saving, that way the program has ALREADY translated the code, and theres no need to translate it at the beginning, which results in faster loading times. 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. I am trying to convert 385 to total hours and minutes in C9 which should.
0 Comments
Read More
Leave a Reply. |