Javier.pcs.crosspost
Excel 2007 November 21, 2008 12:37PM |
David Martin
Re: Excel 2007 November 21, 2008 01:54PM |
// Open Excel via OLE oExcel is object OLE dynamic oExcel = new object OLE "Excel.Application" oExcel>>Visible = OLEFalse // open the workbook l_sXLSFile is string = "I:\MyDocs\TheXLSFile.xls" oExcel>>Workbooks>>Open(l_sXLSFile) //The CONSTANT con_xlLastCell = 11 oExcel>>ActiveCell>>SpecialCells(con_xlLastCell)>>Select Info(oExcel>>ActiveCell>>Row) oExcel>>ActiveWorkbook>>Close oExcel>>Application>>Quit