AddIns

[yliew]

Dear All,

Can someone please give me some direction on how to call the "Random Number Generation" in "Data Analysis" Addins using visual basic?

The following is an attempt to try and record the macro but
it doesn't work. Please help.
_____________

sub random()

Application.Run "ATPVBAEN.XLA!Random", , 18, 18, 2, , 1.4, 0.15

End Sub
____________

Thanks in advance!

Regards,
YEN

 

Works for me...
Try Adding

AddIns("analysis toolpak&quot.Installed = True

My question is similar for the Sample addin. I write:

Application.Run "ATPVBAEN.XLA!Sample", ActiveSheet.Range("$F$3:$F$14&quot, _
ActiveSheet.Range("$C$3:$C$14&quot, "R", 12, False


But cant ignor the dialog box requesting confirmation of overwrite using:
Application.DisplayAlerts = False

 

[yliew]

Thanks for your help. It's working for me now. Thanks!