i need to create a macro that will be used with various workbooks and
worksheets in different files and i am doing it programmatically using
C#, other than adding references and and running the macro from C#.net
everytime i run my program, what are my other options and or how would i
go about doing it -- THANKS in advance

-The problem i am getting with doing it programmatically is that after i
add the macro in, when i go to run it, it says it can't find it,
however i can look in my excel macros and see it there and run it.

Put it into an addin. Put your code into a workbook, and saveas an xla file.
Then load that xla from ToolsAddins.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"tommy" wrote in message
...
i need to create a macro that will be used with various workbooks and
worksheets in different files and i am doing it programmatically using
C#, other than adding references and and running the macro from C#.net
everytime i run my program, what are my other options and or how would i
go about doing it -- THANKS in advance

-The problem i am getting with doing it programmatically is that after i
add the macro in, when i go to run it, it says it can't find it,
however i can look in my excel macros and see it there and run it.

Bob Phillips wrote:

Put it into an addin. Put your code into a workbook, and saveas an xla file.
Then load that xla from ToolsAddins.



THANKS!