C-Sharp (C#) Group: Re: .PrintOut Method

Never mind! The piece of code I was working on opens an existing workbook, and I wasn’;t initializing the worksheet like in my method that creates a new worksheet.  Problem Solved.

 

 

I was successful in printing my _ExcelWB which is an excel workbook object with the PrintOut Method, but when I use the same code for a worksheet object everything goes awry. ; I know I am creating the object right because I can open, modify, etc to the sheet.

 

 

 

I have tried every example on the web I have found.  Can anyone post an example of printing an excel worksheet with the .PrintOut method.

 

 

I have tried:

 

     _ExcelWS.PrintOut(Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing);

 

object _Missing = System.Reflection.Missing.Value;

_ExcelWS.PrintOut(_Missing, _Missing, _Missing, _Missing, _Missing, _Missing, _Missing, _Missing);

 

_ExcelWS.PrintOut(1, 2, 1, false, “MyPrinterR21;, false, false, false);

 

 

I also have wrapped each instance with try/catches, and the only exception I have received is “object reference not set” so I tried ref _Missing, etc…  In most cases nothing was thrown, but nothing printed.  Any help on this issue would be more than appriciated.

 

 

 

Jeremy Schreckhise

           ;