distribution problems; users don't have this and misc

C

cate

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?
 
P

Patrick Molloy

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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top