Load a Calendar Library Object

[chrisjgwhite]

I am trying to use the calendar object on a form in VBA and followed the instructions on other threads for how to load this (ie in references, etc) and I have it all working. The spreadsheet needs to be used by a wide variety of people and I wanted to know if there is a way of automatically loading this reference on each machine as part of the program when it begins to run.

Basically instead of going to each machine to manually load the reference for the calendar I want it to be done as part of the program. any help would be much appreciated.

Thanks

 

[Oorang]

Set it up in an add in and push it down to everyone's add-in folder. (on XP-Pro it will be C:\Documents and Settings\All Users\Application Data\Microsoft\AddIns)

You can make it an add in by simply making one workbook with all the functions you want save it, and rename it with a .xla extension. If you want to really dumb it down, after you have mass distributed the add-in send everyone a work book with this code in a module.

Function Autpen()
Dim AddInName As String
On Error Resume Next
AddInName = "chrisjgwhite"
AddIns(AddInName).Installed = True
If AddIns(AddInName).Installed = True Then
MSBGBox = AddInName & " Installed Correctly."
Application.DisplayAlerts = False
ThisWorkbook.Close
End If
End Function