PC Review


Reply
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average.

Compile VBA Project

 
 
Dave Marden
Guest
Posts: n/a
 
      22nd Feb 2006
I am wondering what Compile VBA project does. I have a regular Excel
project with quite a bit of VBA being used, and I am wondering mostly if
this will compile my project into a installable program.


Thanks,
Dave Marden


 
Reply With Quote
 
 
 
 
=?Utf-8?B?SmltIFRob21saW5zb24=?=
Guest
Posts: n/a
 
      22nd Feb 2006
Nope... you can not make and installable stand alone program. VBA only works
with existing programs. What compiling will do is it will check all of your
syntax and point our any errors in the syntax. You should always compile your
code. If it does not compile then you need to fix it even if it seems to be
running ok. Note that a compiled program can still generate run time errors
so you still need to use error handlers.
--
HTH...

Jim Thomlinson


"Dave Marden" wrote:

> I am wondering what Compile VBA project does. I have a regular Excel
> project with quite a bit of VBA being used, and I am wondering mostly if
> this will compile my project into a installable program.
>
>
> Thanks,
> Dave Marden
>
>
>

 
Reply With Quote
 
 
 
 
Chip Pearson
Guest
Posts: n/a
 
      22nd Feb 2006
VBA is stored in the workbook as byte-codes that correspond to
the text you type in. The actual text is never saved. When you
compile the code, VBA takes these generic opcodes and compiles
them in to platform-specific excodes, which are in turn read by
the run-time libraries when you run the code. VBA will also
compile code as needed at run time. As a practical matter,
clicking Compile just does a syntax check on the project.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Dave Marden" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>I am wondering what Compile VBA project does. I have a regular
>Excel project with quite a bit of VBA being used, and I am
>wondering mostly if this will compile my project into a
>installable program.
>
>
> Thanks,
> Dave Marden
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setup and Deployment project does not compile project with localization Greg Microsoft Dot NET 0 7th Sep 2007 03:52 PM
compile errors when converting web site project to web application project John Dalberg Microsoft ASP .NET 1 28th Mar 2007 01:54 AM
Accesing vba project from wb that has vba project password protected cassidyr1 Microsoft Excel Programming 2 3rd Jul 2004 01:49 PM
Re: VB Standard compile project from VB Pro Project conversion of VB6 Herfried K. Wagner Microsoft VB .NET 1 8th Jul 2003 06:26 PM
Re: VB Standard compile project from VB Pro Project conversion of VB6 Armin Zingler Microsoft VB .NET 0 8th Jul 2003 04:30 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:55 PM.