ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   where do I find docs on excel automation programming? (https://www.excelbanter.com/excel-programming/363717-where-do-i-find-docs-excel-automation-programming.html)

Mike[_108_]

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




All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com