Hi,

Is there any way to do VBA automation in ERPLn session script / DLL. By automation I mean following things:

* Creating excel application object
* Then creating excel workbook object
* Accesing excel worksheet and putting ERPLn table field values into
worksheet cell

Example / documentation if provided would be highly appreciated.

Vishal

I understand copying main table grid to xl is native in ERP Ln (not sure though) . However if u intend todo some query and in Baan launch the data in xl through VBA , u should use auto_open() macros in xl to write code on opening of the file and read , format any data from any file or database table to get data in xl.

I understand copying main table grid to xl is native in ERP Ln (not sure though) . However if u intend todo some query and in Baan launch the data in xl through VBA , u should use auto_open() macros in xl to write code on opening of the file and read , format any data from any file or database table to get data in xl.

Hi Hitesh,

Thanks a lot for your reply. I am exploring possibilities of activating excel and using excel objects like Appl Object -> Workbook Obj -> Worksheet Obj etc from within ERPLn session script or DLL.

Thanks and regards,
Vishal

Such code must be written UI BW executable with a call from standard program . This may not have been documented at all.

Alternatively if user.choice /exits are available , u may trigger xlsx call in such customer baan code .