Novice: Automating Simple Linear Regression with a Button?

[Travis_C]

Hi guys,

I've got a simple regression automation problem that's got me stumped.

I'll try and spell out the problem as explicitly as I can:


Idea is to automate the following process with a button:
-Run simple Analysis Toolpak Regression function one set of paired datapoints
-Have result outputted to separate sheet ("Correlation_Outputs")

Here's what I've done:
-Data is organized in columns on one sheet ("Data_Arrange")
-Button & r-squared output to be displayed on another sheet ("INPUTS")
-Button created using simple button tool
-Macro recorded using basic macro tool, resulting in following VBA code:

"
Sub Regression_Test()
'
' Regression_Test Macro
' Macro recorded 06/09/2006 by
'

'
Sheets("Data_Arrange").Select
Application.Run "ATPVBAEN.XLA!Regress", ActiveSheet.Range("$D$4:$D$39"), _
ActiveSheet.Range("$C$4:$C$39"), False, True, , ActiveSheet.Range("$A$1") _
, False, False, False, False, , False
Sheets("INPUT").Select

End Sub
"

-Macro was assigned to new button
-Button was clicked, resulting in following error:

"
Run-time error '1004':
The macro " cannot be found.
"

I am running Excel 2003 SP2 edition at work on my employer's Window's NT network.

I understand this silly question has probably been posted numerous times, but after searching through the forum (and the Excel online help) I had no luck finding a solution.

Any help you guys (and gals) can offer would be of huge benefit...

Thanks so much!!!

 

[venkat1926]

I can only guess. the solutions may be trivial but mistake can happen anywhere. My aplogies
first check the spelling of the macro name the button-click code.
better to copy the macro name and paste it under the buttonclick
If you have taken the button from the forms toolbar. it is ok. and you assinged the macaro from the list of macros. It shuld be ok

once agan check whethr the main macro works by step debugging-successively hitting F8.