Prev: Charts.Add - Smart, But Oh So Dumb
Next: error handling
From: cate on 17 Dec 2009 21:15
I have discovered that contrary to the IT dept, all company users do
not have identical installations. Well, that's not really that
surprising. Anyhow, I have distributed a wb that has an additional
add-in (analysis tool kit). I have also installed a reference to it
in VBA.

How does someone check to see what is installed? Then what do you do
about it? Can you install it with a VBA program? Is there a way to
'bring along' your add-ins with the wb?


#2
And I've also discovered, here in this group, that DATEDIF was damaged
in an Excel2007 spak. How would I check to verify the release level
and spaks installed?

#3
Is there a replacement for DATEDIF?
From: Patrick Molloy on 18 Dec 2009 05:58
1)
you could call the following sub from the workbook's open event:

Sub testAddIn()

Dim ai As AddIn

For Each ai In Application.AddIns
If ai.Name = "ATPVBAEN.XLA" Then
ai.Installed = True
Exit For
End If
Next

End Sub

this add-in is a standard part of the excel installation, so you shoul;d not
need to port it with the workbook.

2 & 3) use DateDiff
note the 2nd 'f' in xl2007 :)


"cate" <catebekensail(a)yahoo.com> wrote in message
news:bf7024fa-de1f-4318-bbd6-5c46ddadb3ff(a)j19g2000yqk.googlegroups.com...
> I have discovered that contrary to the IT dept, all company users do
> not have identical installations. Well, that's not really that
> surprising. Anyhow, I have distributed a wb that has an additional
> add-in (analysis tool kit). I have also installed a reference to it
> in VBA.
>
> How does someone check to see what is installed? Then what do you do
> about it? Can you install it with a VBA program? Is there a way to
> 'bring along' your add-ins with the wb?
>
>
> #2
> And I've also discovered, here in this group, that DATEDIF was damaged
> in an Excel2007 spak. How would I check to verify the release level
> and spaks installed?
>
> #3
> Is there a replacement for DATEDIF?

 | 
Pages: 1
Prev: Charts.Add - Smart, But Oh So Dumb
Next: error handling