Problem with COM module add-in for Excel

[garmstro]

Hi,

Im a new member and hope Ive chosen the appropriate forum for my question.

Im wondering whether anyone might be able to help me with the following problem.

I have a .NET COM module add-in for Excel, which I wrote in VB back in 2004, and have been using fairly regularly since then.

The Installer package has come with me from job to job and I have never had any problems loading it onto new machines and connecting with Excel. (Provided .NET framework is installed and I have admin rights to the machine)

I havent used the add-in for about six months and recently tried to install it on my current machine (which I have had for 2 years). The installer appears to run OK, but the add-in does not connect with Excel.

I have checked that .NET framework is installed and I have admin rights to the machine.

I dont know what has changed in the past six months that would interfere with the add-in???

Any help would be greatly appreciated.

Thanks & regards,

Grant

PS It may be a red herring, but one thing I have noticed is that when I right-click on the Installer there is no "Run as" option, as appears with other programs. I cant recall whether this has always been the case with the Installer, or whether this is indicative of some security measure that is causing the problem.

 

[JumpyNET]

Im not sure that I can help you, but may I ask which versions of Excel and Windows you have?

If you have Vista you might check if turning of User Account Control does any help.

 

[PlausiblyDamp]

Once you have run the installer does it copy the COM dll to the expected place or is that not happening either?

If you execute the MSI from an elevated command prompt does that make any difference?

 

[garmstro]

Hi Guys,

Thanks for your responses.

JumpyNET, I am running Excel 2002 on XP Professional (Version 5.1.2600 Service Pack 2 Build 2600).

PlausiblyDamp, the installer creates a new destination folder and copies the files over, including the COM dll; please see attached file. Pardon my ignorance but I dont know how to run from the command prompt. Is it as simple as typing in the name of the Installer Package and hitting return?

Thanks & regards,

Grant

 

[PlausiblyDamp]

That is pretty much all that is involved in running from the command prompt. Can you browse to the DLL from within Excel and add it as an addin that way?

 

[garmstro]

Hi PlausiblyDamp,

Thanks for the reply.

I tried typing the name of the add-in through the command prompt, but unfortunately to no avail (Msg unrecognized command).

I tried browsing for the add-in through Excel but I have never been able to install in this way as its a COM module (Msg not valid Add-In).

Thanks for your help.

I will now try recompiling from scratch.

Grant