PC Review


Reply
Thread Tools Rate Thread

C# Excel Add-in

 
 
AAsk
Guest
Posts: n/a
 
      14th Jan 2009
[Reposted here ... originally posted in C# General discussions ... no
answers forthcoming there!]

Why does intellisense not alllow me to add:

using Microsoft.Office.Interop.Excel;

after Microsoft.Office, the only option I have is Core.

2. Why does the example at

http://msdn.microsoft.com/en-us/library/ms173189(VS.80,printer).aspx

which compiles ok NOT work with Excel: I am getting a NAME! error.

I am aware that there are two errors in this example:

a. The namespace should be EXCELLADDIN and not TAXTABLES.
b. And, the RegisterFunction method is missing two lines:

Microsoft.Win32.RegistryKey key =
Microsoft.Win32.Registry.ClassesRoot.CreateSubKey(
"CLSID\\{" + t.GUID.ToString().ToUpper() +
"}\\InprocServer32");
key.SetValue("", @"C:\Windows\System32\mscoree.dll");

Adding the lines & compiling produces no errors BUT I cannot get the
TAX
method to work in Excel.

Thanks for your help.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Paste failed in excel file migrated from Excel 2003 to Excel Handong Chen Microsoft Excel Crashes 1 4th Mar 2010 06:05 PM
Application coded in excel 2000 when used in excel 2003 excel doesnot perform well and takes double the time to give the output Prince Microsoft Excel Programming 4 17th Feb 2009 03:05 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= Microsoft Excel Programming 0 5th Oct 2007 10:26 AM
Excel 2003 crashes loading excel files created Excel 2000 =?Utf-8?B?SmVmZiBMZXdpbiAgQXVzdHJhbGlh?= Microsoft Excel Misc 0 27th Jun 2005 04:20 AM
Why my Excel 2003 don't open excel files by duble click on excel . =?Utf-8?B?VmFseQ==?= Microsoft Excel Crashes 1 20th Jan 2005 03:10 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:35 AM.