-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: rags_rao
Message 3 in Discussion
Sample for excel to pdf (word to pdf is very similar). needs pdf writer insatlled on
ur m/c Excel.Application app = new ApplicationClass();
//app.ActivePrinter = "Acrobat Distiller";
Workbooks workBooks = app.Workbooks;
Workbook workBook = (Workbook
)workBooks.GetType().InvokeMember("Open",BindingFlags.InvokeMethod,null,workBooks,new
object[]{@"C:\Documents and Settings\raghunandanr\Desktop\clsDiabetesReport.xls"});
workBook.PrintOut(1,Type.Missing,1,false,"Acrobat Distiller",true,true,@"C:\Documents
and Settings\raghunandanr\Desktop\clsDiabetesReport.ps");
workBook.Close(false,Type.Missing,Type.Missing);
PdfDistiller dist = new PdfDistillerClass();
//dist.bSpoolJobs = 1;
dist.bShowWindow = 0;
dist.OnJobFail += new _PdfEvents_OnJobFailEventHandler(Fail);
dist.FileToPDF(@"C:\Documents and
Settings\raghunandanr\Desktop\clsDiabetesReport.ps",null,null);
Marshal.ReleaseComObject(dist);
dist=null;
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
