Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |