Problem distributing an Excel .xla file

[kmiles]

I have a workbook that uses the Calendar.xla add-in. It works fine until I attempt to distribute that workbook to other employees via a file download from our website.

Is there a way to make this work without having to manually add the .xla file on each user's PC?

 

[Greg Truby]

You could send them a workbook with some VBA in the _open event handler that would install it for them. But this assumes

• that the workbook you send would not get hung up on macro security which implies that either
  • the user has his security dropped or
  • you have digitally signed the WB and the user has your signature on file and
• that all users have identical network drive mappings.

Here is the example that's in VBE help:

Sub UseAddIn()

    Set myAddIn = AddIns.Add(Filename:="A:\MYADDIN.XLA", _
        CopyFile:=True)
    MsgBox myAddIn.Title & " has been added to the list"

End Sub

 

[kmiles]

Thanks for your help, Greg. I was able to find out that the actual problem I was having was that, even though the MSCAL.OCX file existed on my download PC, it was not registered because I don't use Access.

Once I typed in "regsvr32 c:\windows\system32\mscal.ocx" everything worked fine.

 

[Greg Truby]

Glad you got it sorted out; though it appears that I completely misunderstood your question.