I am trying to automate the regression function in the analysis tool pack. I tried to simply record myself doing a regression. When I run the macro, it cannot find the analysis tool pack. It says ATPVBAEN.XLA could not be found. ATPVBAEN.XLA is the filename that excel recorded when I ran a regression using the analysis tool pack.
Has anyone had this problem?