| Groups | Blog | Home |
dotnet interop : Automation 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. ------------------------- [quoted text, click to view] <aaronfude@gmail.com> wrote in message news:1168608917.770756.195930@s34g2000cwa.googlegroups.com... > 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 >
[quoted text, click to view] RobinS wrote: > 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. [quoted text, click to view] > So you have a > function you have added to EXcel, but now you can no longer use it? Yes. [quoted text, click to view] > Is the function still in the code-behind? Unfortunately, I don't know what the code-behind is. [quoted text, click to view] > > Can you call it using the > Immediate window? Don't know what the "Immediate window" is, but I will look that up now. [quoted text, click to view] > 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. [quoted text, click to view] > > What version are you using of Excel? > 2003 Thanks for trying to help me!!! [quoted text, click to view] > Robin S.
> ------------------------- > <aaronfude@gmail.com> wrote in message > news:1168608917.770756.195930@s34g2000cwa.googlegroups.com... > > 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 > >
[quoted text, click to view] RobinS wrote: > 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. [quoted text, click to view] > So you have a > function you have added to EXcel, but now you can no longer use it? Yes. [quoted text, click to view] > Is the function still in the code-behind? Unfortunately, I don't know what the code-behind is. [quoted text, click to view] > > Can you call it using the > Immediate window? Don't know what the "Immediate window" is, but I will look that up now. [quoted text, click to view] > 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. [quoted text, click to view] > > What version are you using of Excel? > 2003 Thanks for trying to help me!!! [quoted text, click to view] > Robin S.
> ------------------------- > <aaronfude@gmail.com> wrote in message > news:1168608917.770756.195930@s34g2000cwa.googlegroups.com... > > 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 > >
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. ----------------------------------------- [quoted text, click to view] <aaronfude@gmail.com> wrote in message news:1168635719.512227.43880@q2g2000cwa.googlegroups.com... > > RobinS wrote: >> 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. >> ------------------------- >> <aaronfude@gmail.com> wrote in message >> news:1168608917.770756.195930@s34g2000cwa.googlegroups.com... >> > 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 >> > >
Aaron:
[quoted text, click to view] > I have written an automation add-in some time ago that merely adds a The correct place to get help for managed Add-ins is the > 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". > 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 :-)
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |