Excel Automation (Navision 2.60.E)

mickuk

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

Savatage

did you read this one?

http://www.mibuso.com/forum/viewtopic.php?t=927

fb

How about declaring 'xlWorkbook' as 'Microsoft Excel 11.0 Object Library'._Workbook

mickuk

Thanks fb that solved the problem. Tried a different machine which also has a different set of the excel object lib as well.

Thanks again for your help!