Recordin Regression as a Macro

[psychotic]

Hi,

I cant seem to record a regression as a macro and apply it to
"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 Su

 

[psychotic]

Hi,

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

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

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

 

[macropod]

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

 

[Stan Brown]

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.