In VBA one can select multiple worksheets by passing an array. How is this
same thing accomplished using C#?

I would like to select a number of worksheet from the entire workbook for a
print preview. Thus having only the selected worksheets appear in the
preview.
The following shows the entire workbook.

objExcel.Worksheets.PrintPreview(Missing.Value);

Steve

You would have to select the sheets, but then

objExcel.Activewindow.SelectedSheets.PrintPreview( Missing.Value);

I would think.

--
Regards,
Tom Ogilvy

"steve" wrote in message
...
In VBA one can select multiple worksheets by passing an array. How is
this
same thing accomplished using C#?

I would like to select a number of worksheet from the entire workbook for
a
print preview. Thus having only the selected worksheets appear in the
preview.
The following shows the entire workbook.

objExcel.Worksheets.PrintPreview(Missing.Value);

Steve

Thank you for your reponse. It was helpful in printing one selected sheet.
However, I do not know how to programmaticaly select multiple sheets. Also,
I am using Excel 2000.

I have tried:

string[] stuff = {"Raw Data", "Inventory"};
objSheets.get_Item(stuff);
objExcel.ActiveWindow.SelectedSheets.PrintPreview( Missing.Value);

or

string[] stuff = {"Raw Data", "Inventory"};
objSheets.Select(stuff);
objExcel.ActiveWindow.SelectedSheets.PrintPreview( Missing.Value);

But the PrintPreview command throws an error in each case. PrintPreview was
tried on the Workbook and WorkSheets objects also.

also manually selecting each sheet doesn't work either

(Excel.Worksheet)objExcel.Sheets[2]).Select(Missing.Value);
(Excel.Worksheet)objExcel.Sheets[5]).Select(Missing.Value);
objExcel.ActiveWindow.SelectedSheets.PrintPreview( Missing.Value);

Any ideas?

Thank you

Steve


"Tom Ogilvy" wrote:

You would have to select the sheets, but then

objExcel.Activewindow.SelectedSheets.PrintPreview( Missing.Value);

I would think.

--
Regards,
Tom Ogilvy

"steve" wrote in message
...
In VBA one can select multiple worksheets by passing an array. How is
this
same thing accomplished using C#?

I would like to select a number of worksheet from the entire workbook for
a
print preview. Thus having only the selected worksheets appear in the
preview.
The following shows the entire workbook.

objExcel.Worksheets.PrintPreview(Missing.Value);

Steve

Select takes an optional argument when used with worksheets.

Select the first worksheet as you normally would

then select each of the remainder with an argument of False

The false says not to replace the currently selected sheet, but to add the
referenced sheet to the selected sheets.

you also might try

objSheets(stuff).PrintPreview

(obviously the C# equivalent - I don't know anything about C#).

--
Regards,
Tom Ogilvy

"steve" wrote in message
...
Thank you for your reponse. It was helpful in printing one selected sheet.
However, I do not know how to programmaticaly select multiple sheets.
Also,
I am using Excel 2000.

I have tried:

string[] stuff = {"Raw Data", "Inventory"};
objSheets.get_Item(stuff);
objExcel.ActiveWindow.SelectedSheets.PrintPreview( Missing.Value);

or

string[] stuff = {"Raw Data", "Inventory"};
objSheets.Select(stuff);
objExcel.ActiveWindow.SelectedSheets.PrintPreview( Missing.Value);

But the PrintPreview command throws an error in each case. PrintPreview
was
tried on the Workbook and WorkSheets objects also.

also manually selecting each sheet doesn't work either

(Excel.Worksheet)objExcel.Sheets[2]).Select(Missing.Value);
(Excel.Worksheet)objExcel.Sheets[5]).Select(Missing.Value);
objExcel.ActiveWindow.SelectedSheets.PrintPreview( Missing.Value);

Any ideas?

Thank you

Steve


"Tom Ogilvy" wrote:

You would have to select the sheets, but then

objExcel.Activewindow.SelectedSheets.PrintPreview( Missing.Value);

I would think.

--
Regards,
Tom Ogilvy

"steve" wrote in message
...
In VBA one can select multiple worksheets by passing an array. How is
this
same thing accomplished using C#?

I would like to select a number of worksheet from the entire workbook
for
a
print preview. Thus having only the selected worksheets appear in the
preview.
The following shows the entire workbook.

objExcel.Worksheets.PrintPreview(Missing.Value);

Steve