ok , I got the solution :

for(int intSheetCtr =1; intSheetCtr <
objExcelWorkbook.Worksheets.Count ;intSheetCtr++) {
objExcelSheet
(Excel.Worksheet)objExcelWorkbook.Worksheets.get_I tem(intSheetCtr);
objExcelSheet.Activate();
if(intSheetCtr == 1)
objExcelWorkbook.Windows[1].Zoom = 70;
else if(intSheetCtr == 2)
objExcelWorkbook.Windows[1].Zoom = 80;


--
rejij
-----------------------------------------------------------------------
rejijo's Profile: http://www.msusenet.com/member.php?userid=138
View this thread: http://www.msusenet.com/t-187044058