NET WORKING DAYS formula

[Guest]

I have an excel sheet where i am using 'NETWORKINGDAYS' formula to compute
the effort variance. I have this file in a shared directory where i have
multiple users accessing this file. To get the correct value for (Net Working
days) formula, i have enabled Tools - Add-Ins - Analysis Toolpack option on
my machine. i can see the output value of this formula correctly after
enabling the above option.

But if someone else opens this file, they cannot see the formula active ..
they get to see "NAME?" in that cell instead of the figure. they have to
manually enable the analysis toolpack option.

Can someone suggest me the workaround if i can write a VBA macro to get this
value automatically visible whenever anyone opens this file directly from
server or if this file is sent as an attachment, they can view the actual
figures without manually enabling the option?..

note >> i am using Excel 2003 (11.8033.8122) SP2
Thanks,
Chitra

 

[Dave Peterson]

If the addin is installed on the user's pc (depending on the installation, it
doesn't have to be!), you could use a macro like:

Option Explicit
Sub auto_open()
If Application.AddIns("Analysis ToolPak").Installed = False Then
Application.AddIns("Analysis ToolPak").Installed = True
End If
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

(remember that macros need to be enabled by each user, too.)