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!!!
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!!!