ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Managed Code UDF without Excel Services? (https://www.excelbanter.com/excel-programming/427724-managed-code-udf-without-excel-services.html)

Ethan Strauss

Managed Code UDF without Excel Services?
 
Hi,
I would like to be able to write User Defined Functions for Excel 2007
using C#.net in Visual Studio 2008 with using Excel Services. I have found
lots of stuff (e.g. http://msdn.microsoft.com/en-us/library/ms493934.aspx)
for UDFs using Excel services, but I just want to make an add-in with
functions and have those functions available for people who have that add in
even without people connected to a Server. Is that possible? How should I do
it?
Thanks!
Ethan

Chip Pearson

Managed Code UDF without Excel Services?
 
I have step-by-step functions for creating class libraries in NET
whose functions can be called directly from worksheet cells. The
examples are in VB.NET but you can probably translate them to C# with
little effort.

See http://www.cpearson.com/Excel/Creati...nctionLib.aspx for
complete details.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Wed, 29 Apr 2009 09:24:01 -0700, Ethan Strauss
wrote:

Hi,
I would like to be able to write User Defined Functions for Excel 2007
using C#.net in Visual Studio 2008 with using Excel Services. I have found
lots of stuff (e.g. http://msdn.microsoft.com/en-us/library/ms493934.aspx)
for UDFs using Excel services, but I just want to make an add-in with
functions and have those functions available for people who have that add in
even without people connected to a Server. Is that possible? How should I do
it?
Thanks!
Ethan


Ethan Strauss

Managed Code UDF without Excel Services?
 
Thanks!
That looks good. I may have more questions as I start working through it.

Ethan


"Ethan Strauss" wrote:

Hi,
I would like to be able to write User Defined Functions for Excel 2007
using C#.net in Visual Studio 2008 with using Excel Services. I have found
lots of stuff (e.g. http://msdn.microsoft.com/en-us/library/ms493934.aspx)
for UDFs using Excel services, but I just want to make an add-in with
functions and have those functions available for people who have that add in
even without people connected to a Server. Is that possible? How should I do
it?
Thanks!
Ethan



All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com