Re: Compiled, Tokenized or Interpreted?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Bill Martin wrote:
I've been using VBA to do some fairly intense computations in an Excel
spreadsheet. Unfortunately, it's just getting too big and too slow
due to the tokenized and interpreted nature of VBA. So I'm going to
need to move the code to a genuine compiled language.

My question is whether VB is fully compiled, or is it similar to VBA
and tokenized?

Fully compiled, yes. Running VBA code is similar to running VB5/6 code
within the IDE. You can often get an order of magnitude just compiling this
to a pcode EXE. Depending on the code, you may get yet another order of
magnitude improvement compiling to a native EXE. Maybe more. Depending on
the code. If you're accurately diagnosed your bottleneck, you'll see a huge
improvement.

And also, is there a general FAQ available on VB somewhere? Or any
simple speed benchmarks available?

If you google this group for the term "benchmarks" you'll find numerous
threads where different techniques are compared. As for a faq, yeah, google
groups is probably as good as it gets as well. They're all here, and there
are probably a good several hundred that come up repeatedly!
--
Working without a .NET?
http://classicvb.org/


.

Relevant Pages

  • Re: MDB grows on every compile/save
    ... reset VBA and then make code changes. ... >> Tom Unkefer ... >>> But I have not found any that relate to compiling. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compile Error: variable not defined
    ... The macros require the Analysis ToolPak, ... VBA thought that the function being used was a variable. ... ensure that Option Explicit is at the top of each module and ... I tried compiling both copies and they compiled ...
    (microsoft.public.excel.programming)
  • RE: Compile Error: variable not defined
    ... VBA thought that the function being used was a variable. ... variable declaration' turned on in VBA Options which in turn places 'Option ... ensure that Option Explicit is at the top of each module and ... I tried compiling both copies and they compiled ...
    (microsoft.public.excel.programming)
  • Re: VBA Project Compilation - Is It Worth It?
    ... Simon - From what I understand, any VBA from Word 97 will run under VBA 6. ... I was just "upgraded" from 2000 to XP, and had no problems executing code ... does compiling a VBA project have? ... upgrading to Word 2002/VBA 6 in a month's time)? ...
    (microsoft.public.word.vba.general)
  • Re: VBA Documentation
    ... Search news groups with Google ... I can't seem to find> any documentation on the Built-In Dialogs supplied with VBA in Excel. ...
    (microsoft.public.office.developer.vba)