Will ISODD function (Tool Pack function) travel and work with .xls file for any Excel user (97 thru 2003), or will user also have to install Tool Pack for ISODD to work?
Will Tool Pack function travel and work with data file (.xls)?
-
-
-
Re: Will Tool Pack function travel and work with data file (.xls)?
Only if each user / PC has the XLA installed
jiuk
-
Re: Will Tool Pack function travel and work with data file (.xls)?
You could include this in the ThisWorkbook object which would ensure that the addin is always present
Code
Display MoreOption Explicit Const strAddin As String = "Analysis ToolPak" Private Sub Workbook_Open() With Application .StatusBar = "" .DisplayAlerts = False End with If Application.AddIns(strAddin).Installed = False Then Application.AddIns(strAddin).Installed = True If Application.AddIns(strAddin).Installed = True Then MsgBox "Excel Addin-'" & strAddin & "'." & Chr(13) & "Has been installed...", vbExclamation End If End If Application.DisplayAlerts = True End Sub
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!