Reference to ATPVBAEN.XLS

S

Stratuser

I can't find out how to refer to the Regress function of ATVBAEN.XLS in Excel
2007, which we just converted to. Here's the old code that used to work in
Excel 2003:

'Run regression
Application.Run "ATPVBAEN.XLA!Regress", Range("Mgr"), Range("Index"),
False, False, , Sheets("Regression").Range("$A$1"), False, False, False,
False, , False

Excel 2007 doesn't know what this file is. Thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Big dataset - batch process 1
1004 error when using ATPVBAEN.XLAM!Regress 7
VBA for Dependents shortcut menu 0
disabling message 2
Macro to Select text from a point given to a specific word 2
Regression in VBA 3
Macro to sequence ("$A:$A") to ("$IV:$IV") 15
Inputbox/Regression Problem 2

Top