I haven't been able to find the syntax for doing the following in C#:

Sheets(Array("Sheet1", "Sheet3")).PrintOut

Is it possible, how?

I'm no expert on C#, but perhaps the problem is that it doesn't "understand"
the array statement. Perhaps you can create a standard array, put the two
sheet names into it, and then print. Or print as 2 print jobs.

On Tue, 04 Oct 2005 21:59:24 +0200, Mattias Beermann wrote:

I haven't been able to find the syntax for doing the following in C#:

Sheets(Array("Sheet1", "Sheet3")).PrintOut

Is it possible, how?

I figured out the correct syntax today, the error I did before was to
cast the result into the wrong type. If anyone else has the same
problem, the correct solution is:

string[] s = new string[] { "Kunder", "Konsulter" };
Sheets sheets = (Sheets)workbook.Sheets[s];
sheets.PrintOut(Missing.Value, Missing.Value, copies, false, printer,
Missing.Value, true, Missing.Value);