View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
linchih linchih is offline
external usenet poster
 
Posts: 1
Default 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