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/comm...lic.excel.misc

Carlos A wrote:
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?

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


"Carlos A" <Carlos wrote in message
...
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/comm...lic.excel.misc