Excel Automation (Navision 2.60.E)

Hi,

I have read a few articles around this site explaining how to use automation within Navision, however I have come across a few problems. When i try to assign the activeworkbook variable to my own workbook variable i get an assignment error.

xlWorkbooks := xlApplication.Workbooks;
xlWorkBooks.Add;
xlWorkbook := xlApplication.ActiveWorkbook;

Where xlWorkbooks is 'Microsoft Excel 11.0 Object Library'.Workbooks
Where xlWorkbook is 'Microsoft Excel 11.0 Object Library'.Workbook

Now the error message that I am presented with is "Invalid Assignment. It is not possible to assign _Workbook to a Workbook"

I was just wondering if there is anyone that knows how I would be able to resolve this problem? I have tried a number of searches to no avail ](*,)

Any help would be greatley appreciated!

Thanks

Mick