RE: [development-axapta] Re: COM Excel.Application

[Don Price]

xlApp       = new Com('Excel.Application');    xlApp.visible(true);     AppVersion  = xlApp.version();     xlBook      = xlApp.Workbooks();     wb = xlBook.Open(filename);      xlSheets    = xlApp.Worksheets();     Don -----Original Message----- From: Ing. Gonzalo Bastos S. [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 3:38 PM To: [EMAIL PROTECTED] Subject: Re: [development-axapta] Re: COM Excel.Application   That's a good example, but you donīt have code for open and working with an existing excel worksheet ??   Regards ----- Original Message ----- From: k_otickashka To: [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 2:24 PM Subject: [development-axapta] Re: COM Excel.Application       Custtable ct;     int row = 1;     COM excelApp, workbooks, excelCell, excelWorkSheet, workbook;     ;         excelApp = new COM("Excel.Application");         if (excelApp)         {             workbooks = excelApp.Workbooks();             workbooks.add();             excelWorkSheet = excelApp.ActiveSheet();             while select ct             {                 excelCell = excelWorkSheet.Range(StrFmt("A%1", row));                 excelCell.value(StrFmt("%1",ct.AccountNum));                 excelCell = excelWorkSheet.Range(StrFmt("B%1", row));                 excelCell.value(ct.Name);                 row++;             }         }         workbook = excelApp.ActiveWorkbook();         workbook.SaveAs("c:\\temp\\test.xls");         workbooks.close(); --- In [EMAIL PROTECTED], "gonzalo_edo" <[EMAIL PROTECTED]> wrote: > Does anybody know where can I find any documentation about using > Excel.Application COM > > Or anybody has an example to connect Excel with Axapta > > Regards Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/   To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.