ATP or ATP - VBA

[John Michl]

I posted a question (which I have since solved) on a different forum.
I have a model that uses some advanced date functions found in the ATP.
My worksheet includes some VBA code but primarily for sorting and
printing. Nothing in the code references any functions.

On computers that didn't have ATP - VBA installed, the model would
create a warning about links and then show an error message for certain
formulas stating the Name was not understood.

I've solved the problem by including a VBA statement that loads both
ATP addins when the worksheet is opened.

However, I don't understand why ATP - VBA is needed if I don't have any
functions called via VBA.

Thanks.

- John

 

[Bob Phillips]

If you don't call ATP functions from VBA you shouldn't need it. What message
do you get?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[John Michl]

First message is upon opening the file and is the links to external
file message ...

"This workbook contains links to other data sources. If you update the
links..."

If I choose Update, I get a message indicating that some links can't be
updated and do I want to Edit those links. If I say yes, I go to an
Edit Links dialog box where the following info is displayed:
Source: ATPVBAEN.XLA
Type: Worksheet
Update: A
Status: Error: Undefined or non-rectangular name

Also, the formulas containing the WEEKNUM function are changed to
include a path such as:
='C:\Program Files\Microsoft
Office\Office10\LIBRARY\Analysis\ATPVBAEN.XLA'!WEEKNUM(G8)

As for VBA calls...
I now have macro in the worksheet open event that install the ATP and
ATP-VBA addins.
I have four simple macros that sort a table different ways plus
hide/unhide columns and autofit some columns. No functions of any kind
are called in the VBA.

- John