Referring to Cells in Excel by Using Index Numbers

Maybe a little late for an answer but i think you have to do this:

VAR:
Range : 'Microsoft Excel 11.0 Object Library'.Range
App : 'Microsoft Excel 11.0 Object Library'.Application
Workssheet : 'Microsoft Excel 11.0 Object Library'.Worksheet
nCount : integer
// -----------------

CREATE(App); // you probably already did that ...

// your 2nd problem
nCount := App.Worksheets.Count;
Worksheet := App.Worksheets.Add(0,nCount);

// your 1st problem
Range := WorkSheet.Cells.Item(2,3);
Range.Value := SomeValue;

I did not test it, but with this code i think you are close. The only thing i'm not sure of if the worksheets.add works with that 0. Play a little with it. Its an optional paramter but navision does require you to give something.

With your first problem you forgot Item. In VB this is the default property so in VB it is not required. Navision does not know such thing as default property so you have to give the name of the default property (item).

To Your first problem - I think the simplest way is something like this:

xlWorkSheet.Range('A1').Value := 'Text';