Excel/VBA programming

[Guest]

There is no doubt about the adavantages of programming macros and basic code
with an interface made in Excel. Advantages such as portability since pretty
much any computer in world has available Office programs. However, for more
sophisticated research (graduate school) the speed for my programs made on
VBA is much slower than other codes (Fortran, C++ and others). Is it possible
to plan a better memory use and compiling options for future versions of
Excel and its VBA programming capabilities?.

Thank you very much,

Carlos Avila

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...9-a80b3f631c92&dg=microsoft.public.excel.misc

 

[beliavsky]

There is no doubt about the adavantages of programming macros and basic code
with an interface made in Excel. Advantages such as portability since pretty
much any computer in world has available Office programs. However, for more
sophisticated research (graduate school) the speed for my programs made on
VBA is much slower than other codes (Fortran, C++ and others). Is it possible
to plan a better memory use and compiling options for future versions of
Excel and its VBA programming capabilities?.

Why don't you create DLLs from your Fortran and C++ codes and call them
from Excel?

 

[Chip Pearson]

You can write COM Add-Ins in any language you like. These are
compiled native code DLLs which will execute much faster than
VBA. Similarly, you can write standard Win32 DLLs in any language
you like and call functions in those DLLs from VBA code.


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