| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Analysis ToolPak Function in VBA is sloooow
Excel 2003.
I am puzzled by the implementation of ATP function(s) called from VBA. First, after sorting out how to add the references etc., I now see this cryptic text in the debug/immediate window when I open my project: [auto_open] < [SetupFunctionIDs] < [SetupFunctionIDs] [PickPlatform] < [PickPlatform] [VerifyOpen] < [VerifyOpen] 1 [RegisterFunctionIDs] < [RegisterFunctionIDs] [auto_open] So I am using the GCD function. It seems every time I call GCD() I get this interesting information added to the debug window (not put there by me!): [GetMacroRegId] 'GCD' < [GetMacroRegId] 'GCD' - '1412038696' To my question.. the ATP code runs /many times/ slower compared to my hand-rolled VBA GCD function. I expected a performance improvement. What is going on? Could it be that writing so much garbage to the debug window is slowing things down? Is there a way to turn off the verbose messaging? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
| Yield() function missing from XL2007 SP1 ATPVBAEN Analysis ToolPak | Excel Worksheet Functions | |||
| Inserting an analysis toolpak function in a Cell with C# | Excel Programming | |||
| Inserting a analysis toolpak function with C# | Excel Programming | |||
| My XIRR function has dropped out, analysis toolpak doesn't fix. | Excel Worksheet Functions | |||
Threaded Mode
