Are you using Microsoft Office 2007/2010?
I've had issues when running macros from some of the old Devnet applications due to some minor differences in VBA cores in 2007 version of Office.
Can you try it in version 2003 and see if you get the same error?
I know this is not a solution, but it can help isolate the real problem.
It's Excel 2002 SP3 running on XP SP2
Upgrading from Excel 2002 to Excel 2003 didn't help...same error. Any other suggestions?
Does it work if you login to your computer with any other Windows account and add it to the Excel add-in list?
How are you using it? Did you add it to the list of Excel add-ins, in the same way usually done for DataLink, Tag Configurator, MDB Builder, etc (i.e., Tools > Add-Ins > Browse)? Or are you just opening the OSIDevNetArchiveAnalyser.xla as you open any other xls file?
Are you using it on the same computer where it worked once? Has the computer hard disk never been formatted since then?
I am using the Archive Analyser with no problems on my laptop with Excel 2003. After some research, I found out that a key in the Windows registry is created for the add-in in the following path:
where <SID> is the security identifier of your Windows account. Microsoft Office 11.0 is the same as Microsoft Office 2003.
In order to find out the SID of your Windows account, you can create a text file with the a VBScript like the following (named UserSID_script.vbs, for instance) and run it:
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set objAccount = objWMIService.Get _
(by the way, I'm not a VBScript expert: just took this script from Hey, Scripting Guy! Blog How Can I Determine the SID for a User Account).
Maybe the name of that registry key on your computer has an old path where you ran the Archive Analyser add-in previously from? In any case, it's curious that the add-in menu options are loaded and the problem only manifests when you click on any of the options, right?
Just checked with Excel 2007 - works fine. So - how are the security settings for Macros/Add-Ins? Is PI Datalink installed and working?
Craig, go to the project references and make sure there isn't a missing reference.