garmstro Posted March 19, 2009 Posted March 19, 2009 Hi, I'm a new member and hope I've chosen the appropriate forum for my question. I'm 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 haven't 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 don't 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 can't 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. Quote
JumpyNET Posted March 20, 2009 Posted March 20, 2009 I'm 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. Quote
Administrators PlausiblyDamp Posted March 20, 2009 Administrators Posted March 20, 2009 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? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
garmstro Posted March 22, 2009 Author Posted March 22, 2009 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 don't 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, GrantPCDM Folder.doc Quote
Administrators PlausiblyDamp Posted March 27, 2009 Administrators Posted March 27, 2009 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? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
garmstro Posted March 30, 2009 Author Posted March 30, 2009 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 it's a COM module (Msg not valid Add-In). Thanks for your help. I will now try recompiling from scratch. Grant Quote
Recommended Posts