Can someone help me setup a new device in Baan so that I can print any Baan report directly to Excel just as if I were printing it to Windows Printer ?

Thanx in advance

Of course:

Device type : rewrite file
4Gl Program: ttstpconv
Argument: ASCII:excel.exe
Path: c:\tmp.xls

Regards,
Han

Hi,

It works not too bad but it seems that it generate a plain ascii file format. And so when it is loaded by excel it is not very usable.

Is there any way to improve that?

providing the report has some form of delimiter i.e. comma or pipe then you can use Excel's text to columns function to make the data more workable.

As stated to get a more readable solution you have to convert text to columns. However our company has developed a ttstpconv script that makes it usable in excel at once.

Regards,
Han

Hans,

Is-it possible that you post some information about the way to create a script than can be used in a device like ttstpconv script?

There is a copy of this in the Code and Utilities Forum (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=513) that you can download and work with. This version only starts excel. I have another version that uses a table and based on the report in starts different macros. Hope it is what you are looking for.

Mark

Thank you mark,

it seems very usefull.

Thanx everybody for the quick and generous help. It works very well for us. I intend using this forum more often.

Thanx once again.....