Help-Files or Documentation for Excel Automation in Navision

Hubert

Hi,

I have always the problem, that the Syntax of Excel - Automation is different to the Helps in the Microsoft Databases. They only give samples for C++ and .NET. But there are no samples for C/AL.

Does anybody know, if there is a documentation existing for that syntax?

Actually you want to change a property like charttype(?) - you can only fill in numbers, but in the Microsoft Documents you only find the properties in text not the numbers.

I hat this try and error game.
Has anybody a documentation of that objects and syntax in Navision?

Thanks,
Hubert

kine

Best way is to take the header files from visual studio or some other development application (borland etc.) and take the constants from there (see for example file excel_2k.h) or you can look there: http://www.geocities.com/ResearchTriang ... excel8.htm

Eugene

one more tip : when automating excel one can record macroses in Excel in its Visual Basic and then copy paste it to your automation controller edit according to its own programming language rules and voila