LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default Calling Excel user defined function from C#

Hi,

I have an excelsheet with a function called FillCell1:

Public Function FillCell1()
Range("C9").Select
ActiveCell.FormulaR1C1 = "10"

End Function

This functions enters the value "10" in cell "C9". I would like to call this
function from a C# application. Is this possible? I heard that this is
possible but when i look for some examples on the internet i can't hardly
find such examples.
Can someone help me with this?
I know how to open an excelsheet and enter a value through the excel object.
The point is that i already have an existing sheet in which code is written
to enter the value in the cell, so i don't want to write that piece of code
in my C# application again but just want to call this function to do so.

Thanks,

Stanley
 
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
User Defined Function is not working for me in Excel 2007 Abdi Excel Discussion (Misc queries) 1 November 18th 08 10:50 PM
How to call a function of an user defined DLL from Excel? Davide[_2_] Excel Programming 3 May 9th 06 02:50 PM
Calling user defined function from C/C++ Ravil Excel Programming 0 April 24th 06 06:05 PM
How can I create a user defined function in excel? Martinj Excel Discussion (Misc queries) 4 August 20th 05 06:11 PM
How to create User Defined function in Excel Johnny Ko Excel Programming 2 December 5th 03 09:09 AM


All times are GMT +1. The time now is 07:22 PM.

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

About Us

"It's about Microsoft Excel"