Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access toolpak program from Addins
I am trying to access Histogram analysis functionality from Data Analysis
addin from within VBA but it couldn't find the macro even when I point it to the folder where the file ATPVBAEN.XLA resides. I originally recorded the statement as a macro and edit the program from there. The following statement does not work in VBA. Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("$B$11:$B$178") _ , ActiveSheet.Range("$G$3"), ActiveSheet.Range("$A$11:$A$19"), False, True _ , True, False Any suggestion? -- Gracebewithyouall |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access toolpak program from Addins
You need to load the addin named 'Analysis ToolPack - VBA' to run the
procedures in VBA code. Your code should run OK -- Cheers Nigel "linchih" wrote in message ... I am trying to access Histogram analysis functionality from Data Analysis addin from within VBA but it couldn't find the macro even when I point it to the folder where the file ATPVBAEN.XLA resides. I originally recorded the statement as a macro and edit the program from there. The following statement does not work in VBA. Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("$B$11:$B$178") _ , ActiveSheet.Range("$G$3"), ActiveSheet.Range("$A$11:$A$19"), False, True _ , True, False Any suggestion? -- Gracebewithyouall |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Access program | Excel Discussion (Misc queries) | |||
How do I access an unopened spreadsheet from a program? | Excel Programming | |||
Excel/Access Program | Excel Programming | |||
Calling Access Program from Excel | Excel Programming | |||
How to access a called sub program to edit? | Excel Programming |