 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / .NET Framework / Interop / January 2007Automation add-in stopped working, please help.
Hi, I have written an automation add-in some time ago that merely adds a few functions to Excel. It has always worked, but now it has stopped! When used in a cell, I get "#NAME?". When called via VBA it says "The macro 'sqr' cannot be found". I have tried everything I could think of... Recompile, reinstall, remove then reinstall, reinstall the .NET Framework (it's 2.0), etc but nothing changes. It still shows up in the automation list and gets added to the list of Add-ins without a problem. It's just that the functions are no longer available in Excel. My next step is going to be to reinstall the entire system. Can someone please help me save myself from it? Many thanks in advance! Aaron Fude Does the code exist in Excel, is that what you mean? So you have a function you have added to EXcel, but now you can no longer use it? Is the function still in the code-behind? Can you call it using the Immediate window? Is the function declared a public? What version are you using of Excel? Robin S. ------------------------- > Hi, > [quoted text clipped - 16 lines] > > Aaron Fude > Does the code exist in Excel, is that what you mean? The function is written in C#. The library shows up under Automation and in the Add-ins list. > So you have a > function you have added to EXcel, but now you can no longer use it? Yes. > Is the function still in the code-behind? Unfortunately, I don't know what the code-behind is. > Can you call it using the > Immediate window? Don't know what the "Immediate window" is, but I will look that up now. > Is the function declared a public? Yes, in C#. Like I said, it's always worked and has now inexplicably stopped. So it can't be anything wrong with the function b/c thecode itself has not been changed in some time. > What version are you using of Excel? 2003 Thanks for trying to help me!!! > Robin S. > ------------------------- [quoted text clipped - 18 lines] > > > > Aaron Fude > Does the code exist in Excel, is that what you mean? The function is written in C#. The library shows up under Automation and in the Add-ins list. > So you have a > function you have added to EXcel, but now you can no longer use it? Yes. > Is the function still in the code-behind? Unfortunately, I don't know what the code-behind is. > Can you call it using the > Immediate window? Don't know what the "Immediate window" is, but I will look that up now. > Is the function declared a public? Yes, in C#. Like I said, it's always worked and has now inexplicably stopped. So it can't be anything wrong with the function b/c thecode itself has not been changed in some time. > What version are you using of Excel? 2003 Thanks for trying to help me!!! > Robin S. > ------------------------- [quoted text clipped - 18 lines] > > > > Aaron Fude I don't know how to fix this because I haven't written add-ins to Excel. I know how to write VBA code within Excel, and I know how to use OLE Automation to automate Excel from VB and VB.Net, but that doesn't seem to apply here. I recommend that you post this to microsoft.public.excel.programming. Someone there can probably help you a lot quicker than I can. Good luck. Robin S. ----------------------------------------- >> Does the code exist in Excel, is that what you mean? > [quoted text clipped - 55 lines] >> > >> > Aaron Fude Aaron: > I have written an automation add-in some time ago that merely adds a > few functions to Excel. It has always worked, but now it has stopped! > When used in a cell, I get "#NAME?". When called via VBA it says "The > macro 'sqr' cannot be found". The correct place to get help for managed Add-ins is the office.developer.add_ins newsgroup. When you post there, be sure to mention the software versions (both dev as well as Office). Also mention where the sqr function is located (is it in your Add-in)? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.