Automation and Excel

Hello folks, I have following problem, i open an Excel Sheet with 10 Sheet, my Code : CREATE(xlApp); xlBook := xlApp.Workbooks.Add(’\\Financials\Marketing\Robert\xxx.xls’); xlSheet := xlApp.ActiveSheet; xlSheet.Name := ‘Sales Provision’; xlApp.Visible := TRUE; Now, i want to put some date in diffrent Sheets, eg. sheet A become some data Sheet B become some data, … and so on. How can i actived the diffrent Sheets and put data in it ! ------------ Best regards Alejandro Schubert

try this: xlSheet := xlBook.Worksheets.Item(‘name’); xlSheet.Activate; christian reisinger NAVIConsult AG