Cross platform VBA issue

[Wallace, William]

When Windows users create a worksheet that uses the WORKDAY function from
the analysis toolpak for VBA, that document frequently returns the #NAME
error in the cells referencing the function when the document is opened by
Mac users. Our Macs are running Office 2004 under OS X 10.3.9 with the
Analisys toolpak for VBA enabled. Anybody else seen this issue? Know how to
resolve it?

Thanks.
--
Bill Wallace
Macintosh Technical Specialist
Wright Group/McGraw-Hill
130 East Randolph, Suite 400
Chicago, IL 60601
312-233-6794
(e-mail address removed)

 

[JE McGimpsey]

When Windows users create a worksheet that uses the WORKDAY function from
the analysis toolpak for VBA, that document frequently returns the #NAME
error in the cells referencing the function when the document is opened by
Mac users. Our Macs are running Office 2004 under OS X 10.3.9 with the
Analisys toolpak for VBA enabled. Anybody else seen this issue? Know how to
resolve it?

I don't see that - I get a correct return if either the ATP or the
ATP-VBA is loaded in XL04.

Does recalculating the workbook solve the problem (using F9)? Do other
ATP functions work?

 

[Bob Greenblatt]

When Windows users create a worksheet that uses the WORKDAY function from
the analysis toolpak for VBA, that document frequently returns the #NAME
error in the cells referencing the function when the document is opened by
Mac users. Our Macs are running Office 2004 under OS X 10.3.9 with the
Analisys toolpak for VBA enabled. Anybody else seen this issue? Know how to
resolve it?

Thanks.
--
Bill Wallace
Macintosh Technical Specialist
Wright Group/McGraw-Hill
130 East Randolph, Suite 400
Chicago, IL 60601
312-233-6794
(e-mail address removed)

You may have the Analysis tool pack VBA installed, but is the analysis tool
Pack Installed? This provides the correct worksheet functions.

 

[Wallace, William]

I don't see that - I get a correct return if either the ATP or the
ATP-VBA is loaded in XL04.

Does recalculating the workbook solve the problem (using F9)? Do other
ATP functions work?

I have both ATP and ATP-VBA loaded. Recalculating does not help. This
problem does not always occur, so I suspect its cause lies in the way the
document was created.