By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,662 Members | 1,141 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,662 IT Pros & Developers. It's quick & easy.

Automated Regression

P: 1
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?
Feb 27 '07 #1
Share this Question
Share on Google+
1 Reply


100+
P: 1,646
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?
Ah yes Excel. Interestingly we don't have an excel forum for questions like this. Doesn't mean we can't find an answer though. If there are not too many steps involved could you go through what you had to do to record this macro?
Feb 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.