Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
Add-In's
Name:
Dan Featherstone
Email (spam proof):
Email the originator of this post
Date:
Thursday, August 12, 2004
Hits:
75
Discussion (Terms and Conditions):
We've got a application with some VBA coding behind where it looks for a particular add-in which was built especially for the application. The problem is we've just upgraded from Excel 97 to Excel 2003, and when the user tries to run the application is say's "Add-in not found" but it's in the location it's look at. Are there any differences between Excel 97 and 2003? The line of coding it falls over on is: MainXLALongName = ThisWorkbook.Path & "\" & ksAxaAutoJournal With fSearch .LookIn = ThisWorkbook.Path .FileName = sMainXLALongName .Execute .MatchTextExactly = True If Application.FileSearch.FoundFiles.Count > 0 Then bFoundMainXLA = True Else sErrorMsg = "The AxaAutoJournal.xla file has not been found in Path : " & ThisWorkbook.Path & " !!" sErrorMsg = sErrorMsg & vbCrLf & "Can not Continue! The AxaAutoJournal will now close." MsgBox sErrorMsg, vbCritical, "AxaAutoJournalV7" End End If

Sponsored by the best FTP application on the internet: