I recorded the following excel macro:
VB Code:
Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("$G$4:$G$8"), _ "NewName", , False, True, True, False
I want to do this programatically from VB.
Here is my code:
VB Code:
Set wAddin = OutputSheet.Application.Workbooks.Open(AddIns(1).FullName) Application.AddIns(AddIns(1).Title).Application.Run "Histogram", Sheet1.Range(strTemp), _ "NewName", , False, True, True, False
I get the error "The macro "Histogram" cannot found". I also tried a ! preceding Histogram ... same results ..
How can I make this work?
Thanks in advance for any help!




Reply With Quote