Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.vsnet.vstools.office
|
|||
|
|||
calling C# code from excel
"Jason" wrote in message
om... I'm working on a prototype program and have run into a snag. I am trying to call some C# code that I have written from within Excel and can't figure out how to register my methods as macros or formulas within the excel environment. Hi Jason, If you don't like the idea of going down the XLL approach that Geoff suggested, you should (in theory) be able to do it by building a managed COM Add-In, but I don't know how to expose the methods from the AddIn to Excel. Just making them public doesn't seem to help. Maybe the Excel programming group knows? [added] Peter -- Peter Torr - http://weblogs.asp.net/ptorr/ This posting is provided "AS IS" with no warranties, and confers no rights Samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm |
#2
Posted to microsoft.public.excel.programming,microsoft.public.vsnet.vstools.office
|
|||
|
|||
calling C# code from excel
Your .NET assembly needs a COM interop wrapper and your Excel project
needs VBA wrapper functions to call the functions in your DLL. -- "Peter Torr \(MS\)" wrote in message ... "Jason" wrote in message om... I'm working on a prototype program and have run into a snag. I am trying to call some C# code that I have written from within Excel and can't figure out how to register my methods as macros or formulas within the excel environment. Hi Jason, If you don't like the idea of going down the XLL approach that Geoff suggested, you should (in theory) be able to do it by building a managed COM Add-In, but I don't know how to expose the methods from the AddIn to Excel. Just making them public doesn't seem to help. Maybe the Excel programming group knows? [added] Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling VBA code from html or javascript | Excel Discussion (Misc queries) | |||
Calling a bit of code from a sheet errors | Excel Discussion (Misc queries) | |||
Calling Match function from code | Excel Programming | |||
Calling an XLA macro from code | Excel Programming | |||
Calling HTML Source code from within VBA for Excel | Excel Programming |