View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RJQMAN[_2_] RJQMAN[_2_] is offline
external usenet poster
 
Posts: 54
Default File Size - VBA vs Excel Formulas

On May 17, 2:17*pm, FatBytestard
wrote:
On Fri, 15 May 2009 15:34:32 -0700
wrote:



Still searching for the answer. *I just do not understand.


* Perhaps an excel "formula" is really an elaborate VBA script so that
your construct of a particular function will always have a lot more
overhead than using VBA directly. (I do not know. It is likely direct C
constructs or assembler even) (see, I have no Idea). :-)

*Chewing right on the bone, as it were, as opposed to having to gnaw on
the gristle for a while first. *:-)


I tried re-writing a major section of the program in VBA - it seemed
to lower the program size slightly - about 10% - but not as much as I
had hoped for. Just a FYI. Thanks for responding.