Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » VBA » What kinds of different from "Compile VBA Project" to "Compile VB Project"(VB6.0)?

What kinds of different from "Compile VBA Project" to "Compile VB Project"(VB6.0)?

Previous | Next
Latest post Thu, Apr 24 2008 6:29 AM by Jan Karel Pieterse. 4 replies.

  • Tue, Apr 22 2008 10:48 PM

    • homt398
    • Top 50 Contributor
    • Joined on Tue, Jan 15 2008
    • Peking, China
    • Posts 12
    • Points 167

    What kinds of different from "Compile VBA Project" to "Compile VB Project"(VB6.0)?

    Reply |Contact

    Is there different from  "Compile VBA Project" to "Compile VB Project"?

    www.officefans.net

    Jonathan Kuo

    Regards
    Filed under:
    • Post Points: 21

  • Wed, Apr 23 2008 12:57 AM In reply to

    Betreft: What kinds of different from "Compile VBA Project" to "Compile VB Project"(VB6.0)?

    Reply |Contact |Mark as Answer

    Not that I know of. The compiled code gets saved with the workbook and increases its size. When compiled, code starts a bit faster the first time.

    Regards, Jan Karel Pieterse www.jkp-ads.com
    • Post Points: 37

  • Wed, Apr 23 2008 1:23 PM In reply to

    • Mattheq
    • Top 25 Contributor
    • Joined on Wed, Apr 23 2008
    • Perth, Australia
    • Posts 15
    • Points 219

    Re: Betreft: What kinds of different from "Compile VBA Project" to "Compile VB Project"(VB6.0)?

    Reply |Contact |Mark as Answer

     I have noticed that some VSTO database code is very slow when run first time, but is then comparable to VBA speed on subsequent use in the same session.  Is this normal behaviour?  I haven't used VB6 code, so I can't make a comparison with that.

    I have come across something called "Just In Time" compiling.  Is this related to the performance lag in VSTO?

    Regards, Matthew
    Filed under: , ,
    • Post Points: 5

  • Wed, Apr 23 2008 2:38 PM In reply to

    • Jim Thomlinson
    • Top 10 Contributor
    • Joined on Thu, Jan 10 2008
    • Vancouver, Canada
    • Posts 84
    • Points 1,256

    Re: Betreft: What kinds of different from "Compile VBA Project" to "Compile VB Project"(VB6.0)?

    Reply |Contact |Mark as Not Answer

    Jan Karel Pieterse:
    When compiled, code starts a bit faster the first time
     

    According to this site you are usually better of not being compiled as the code compiled faster than it is read.

    http://orlando.mvps.org/VBADecompilerMore.asp?IdC=OrlMoreWin

     
    • Post Points: 21

  • Thu, Apr 24 2008 6:29 AM In reply to

    Betreft: Re: Betreft: What kinds of different from "Compile VBA Project" to "Compile VB Project"(VB6.0)?

    Reply |Contact |Mark as Answer

    I agree with what Orlando writes.

    Regards, Jan Karel Pieterse www.jkp-ads.com
    • Post Points: 5
Page 1 of 1 (5 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.