Recordin Regression as a Macro

Hi,

I cant seem to record a regression as a macro and apply it to a "button"...

Wat i did:
Started "Record New Macro", started "Relative Referencing"...
den i went to "Data Analysis", "Regression"
Entered the X & Y input values using "Ctrl, Shift, Down"
"Stop Recording"
Applied to "button"

but, it showed "run-time error 1004"
ATPVBAEN.XLA could not be found.

can someone help mi?

went to editor and tis is as follows:

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 10/31/2005 by Psychotic
'

'
Application.Run "ATPVBAEN.XLA!Regress", , , False, True, , , False, _
False, False, False, , False
ActiveWindow.SmallScroll Down:=-30
End Sub

Hi,

i juz realised tat i need to install the add-in: Analysis ToolPak-VBA

However, i encountered another problem... it said "input Y range missing. pls enter".

Ani help? did i do sumtink wrong when recording the macro?

Maybe you should post this in an Excel vba Forum ...


"psychotic" wrote in message
news

Hi,

i juz realised tat i need to install the add-in: Analysis ToolPak-VBA

However, i encountered another problem... it said "input Y range
missing. pls enter".

Ani help? did i do sumtink wrong when recording the macro?


--
psychotic

Mon, 31 Oct 2005 06:41:21 +0000 from psychotic
:
i juz realised tat i need to install the add-in: Analysis ToolPak-VBA

_And_ you need to use Excel. This is a MS Word newsgroup. :-)

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/