where do I find docs on excel automation programming?
From c# I start excel, open a workbook and run a specfic macro. I have code
to do this but I don't know how to pass a parameter to the macro and I
cannot find an documentation on it.
This is my code, I believe one of the missing.values can be a parameter but
not sure
oXL.Workbooks.Open(strFileName, 0, false, 5, "", "", false,
Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
oXL.Application.Run("ThisWorkbook.ProcessKrunFile" ,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value);
thanks
|