macro advice

T

tommy

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.
 
B

Bob Phillips

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

--

HTH

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