Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Kill a Reference - Arrrgh!
I embed an optimization library in Excel models. I installed a new
version of the optimizer in it's own directory. However, when I try to point the Reference to the new folder location, it keeps pointing back to the original. I even renamed the original folder to see if causing it to be "missing" would force the redirect. That does not work. See what I mean? How do I kill an obsolete Reference. Can I declare the Reference in the code inself? Any ideas? Thanks, Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Kill a Reference - Arrrgh!
Register the DLL with RegSvr32. Quit Excel, then go to the Windows
Start menu. Choose Run and enter: RegSvr32 "C:\YourPath\YourDLL.dll" Then open Excel and check the references. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Tue, 21 Apr 2009 10:24:33 -0700 (PDT), SteveM wrote: I embed an optimization library in Excel models. I installed a new version of the optimizer in it's own directory. However, when I try to point the Reference to the new folder location, it keeps pointing back to the original. I even renamed the original folder to see if causing it to be "missing" would force the redirect. That does not work. See what I mean? How do I kill an obsolete Reference. Can I declare the Reference in the code inself? Any ideas? Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrrgh. Ok please help, formulae language driving me completely ma | Excel Discussion (Misc queries) | |||
Kill a Macro? | Excel Programming | |||
Kill | Excel Programming | |||
'Kill' | Excel Programming | |||
AutoFill KILL | Excel Programming |