Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
UDF + managed code Michal Excel Programming 1 March 26th 09 02:13 PM
Managed code error handling from VBA Prasanna Excel Programming 0 January 10th 08 04:02 PM
Udfs and eventhandler for excel in managed code [email protected] Excel Programming 0 February 15th 07 10:52 AM
refedit control in 2003 and managed code add-in? Nick Hodge Excel Programming 2 September 7th 04 03:16 PM
.Net Managed Code - Excel Francois[_3_] Excel Programming 0 August 12th 04 07:37 AM


All times are GMT +1. The time now is 07:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"