Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Copy Add-in To Library Error
Hello,
I have a Workbooks_Open macro that uses this code to look for a specific add in. Dim AddCount, AddNo As Integer Dim vPath As String AddCount = Application.AddIns.Count If AddCount 0 Then For AddNo = 1 To AddCount If AddIns(AddNo).Name = "ERAC_TranslateAddIn.xla" Then vPath = AddIns(AddNo).Path Dim ChkFile$ ChkFile$ = Dir(vPath & "\ERAC_TranslateAddIn.xla") If ChkFile = "ERAC_TranslateAddIn.xla" Then AddIns("Erac_Translateaddin").Installed = True Else vPath = "" End If End If Next AddNo End If If it is not found it uses this to add the add in. AddIns.Add Filename:= _ "\\fscorp00\Corp_Public\Groups\Corporate Accounting\AutoMonarch\Excel_Add_Ins\ERAC_Translat eAddIn.xla" Some users get a run time error "Unable to copy add-in to library". Any idea why that happens or what I can do about it? Is there anything special about copying add ins? Thanks, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Find Project or Library Error | Excel Discussion (Misc queries) | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
VB Error Object Library Not Registered | Excel Discussion (Misc queries) | |||
Unable to find project or library - Please help. | Excel Programming | |||
Project-Library Error | Excel Programming |