| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can VB execute VBA code?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can VB execute VBA code?
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can VB execute VBA code?
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can VB execute VBA code?
It is very unlikely that compiling your VBA macro using VB6 will make it run
any faster. The only known exceptions a - 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" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can VB execute VBA code?
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 a - 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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Execute code from book1 of code from book2 | Excel Programming | |||
| Faster Way to Execute Code | Excel Programming | |||
| Execute Code | Excel Programming | |||
| how to execute macro from vb 6.0 code? | Excel Programming | |||
| Code won't execute... | Excel Programming | |||
Linear Mode
