Adressing excell cellars from Navision Financials

Philip_Depuydt

I would like to read some information from a particular cellar in excel into NF 2.0D. I think this should be possible by using "automation controller". Can anyone send me an exemple of how locating a cellar in excel and recuperate the data in Navision.

Thanks for any information.

fredh

C/AL Variables :
1. ExcelApplication - Automation - 'Microsoft Excel 9.0 Object Library'.Application
2. ExcelSheet - Automation - 'Microsoft Excel 9.0 Object Library'.Sheets
3. ExcelWorkSheet - Automation - 'Microsoft Excel 9.0 Object Library'.Worksheet

1 Excel file saved as File1.xls. Following code opens the file and gets the value of the C8 cellar back :

CLEARALL;
CREATE(ExcelApplication,TRUE);
ExcelApplication.Visible := FALSE;

ExcelApplication.Workbooks.Open('E:\FILE1.XLS');
ExcelSheet :=ExcelApplication.ActiveWorkbook.Worksheets;
ExcelWorkSheet := ExcelSheet.Item('Sheet1');
MESSAGE(FORMAT(ExcelWorkSheet.Range('C8').Value));

---

fhh