View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike[_108_] Mike[_108_] is offline
external usenet poster
 
Posts: 2
Default 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