Posted to microsoft.public.excel.programming

external usenet poster

Posts: 63

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with ATPVBAEN.XLA	Zaman	Excel Programming	2	December 29th 06 08:16 AM
atpvbaen link	Dean[_8_]	Excel Programming	5	November 17th 06 08:33 PM
Atpvbaen.xls	FilippoRotolo	Excel Worksheet Functions	0	July 14th 06 05:47 PM
ATPVBAEN.xls Not Found	Stratuser	Excel Programming	1	April 23rd 05 01:32 AM
atpvbaen.xls	mike allen[_2_]	Excel Programming	4	December 24th 04 09:10 PM

All times are GMT +1. The time now is 05:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us