AddIns
AddIns
(OP)
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
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





RE: AddIns
Try Adding
AddIns("analysis toolpak").Installed = True
My question is similar for the Sample addin. I write:
Application.Run "ATPVBAEN.XLA!Sample", ActiveSheet.Range("$F$3:$F$14"), _
ActiveSheet.Range("$C$3:$C$14"), "R", 12, False
But cant ignor the dialog box requesting confirmation of overwrite using:
Application.DisplayAlerts = False
RE: AddIns