My VBA macro runs slowly in Excel 2007. Will Visual Basic compile my VBA
macro into a faster application that I can somehow use with my Excel
spreadsheet?
--
TomThumb

yes - with slight code changes -- you will have to reference the excel object
from within vb.

"TomThumb" wrote:

> My VBA macro runs slowly in Excel 2007. Will Visual Basic compile my VBA
> macro into a faster application that I can somehow use with my Excel
> spreadsheet?
> --
> TomThumb

VBA is a subset of VB... you can run Excel code but will it be faster? First
try to see why your code is slow... then if you find that it is slow because
it runs in Excel then move to VB...

You may send the file to me if it does not contain confidential information
so that I can take a look.
"TomThumb" wrote:

> My VBA macro runs slowly in Excel 2007. Will Visual Basic compile my VBA
> macro into a faster application that I can somehow use with my Excel
> spreadsheet?
> --
> TomThumb

It is very unlikely that compiling your VBA macro using VB6 will make it run
any faster.

The only known exceptions are:
- using a large number (1000s) of VBA UDFs (bypassable in Manual Mode)
- very intensive arithmetic (eg iteratively solving partial differential
equations)

Make sure you have:
- switched off the Google Office COM Addins
- used Application.Screenupdating=False
- switched to manual calculation mode
- cleaned up your code to eliminate selecting ranges
- transferred data between Excel and VBA in large blocks using variant
arrays

regards
Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"TomThumb" <(E-Mail Removed)> wrote in message
news:EBF71729-B2E0-437C-9227-(E-Mail Removed)...
> My VBA macro runs slowly in Excel 2007. Will Visual Basic compile my VBA
> macro into a faster application that I can somehow use with my Excel
> spreadsheet?
> --
> TomThumb

Since there seems to be disagreement as to a speed advantage for VB over VBA,
I will try manual calculation mode as a cheap fix. Thanks to you all (3).
--
TomThumb


"Charles Williams" wrote:

> It is very unlikely that compiling your VBA macro using VB6 will make it run
> any faster.
>
> The only known exceptions are:
> - using a large number (1000s) of VBA UDFs (bypassable in Manual Mode)
> - very intensive arithmetic (eg iteratively solving partial differential
> equations)
>
> Make sure you have:
> - switched off the Google Office COM Addins
> - used Application.Screenupdating=False
> - switched to manual calculation mode
> - cleaned up your code to eliminate selecting ranges
> - transferred data between Excel and VBA in large blocks using variant
> arrays
>
> regards
> Charles
> __________________________________________________
> The Excel Calculation Site
> http://www.decisionmodels.com
>
> "TomThumb" <(E-Mail Removed)> wrote in message
> news:EBF71729-B2E0-437C-9227-(E-Mail Removed)...
> > My VBA macro runs slowly in Excel 2007. Will Visual Basic compile my VBA
> > macro into a faster application that I can somehow use with my Excel
> > spreadsheet?
> > --
> > TomThumb
>
>
>