ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reference to ATPVBAEN.XLS (https://www.excelbanter.com/excel-programming/431169-reference-atpvbaen-xls.html)

Stratuser

Reference to ATPVBAEN.XLS
 
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.


All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com