Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 45

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 18th January 2006, 13:51
en@frrom en@frrom is offline
Join Date: Aug 2003
Location: Belgium
Posts: 1,219
en@frrom will become famous soon enough
Baan: B50B - DB: Oracle 8.0 - OS: Win2k AS
Joedi, terrific!! Works perfectly! Thanks a lot!
Reply With Quote
Old 9th May 2017, 08:11
patelhemansh990's Avatar
patelhemansh990 patelhemansh990 is offline
Join Date: Oct 2013
Location: Surat
Posts: 2
patelhemansh990 is on a distinguished road
Baan: ERP LN FP7 and FP9 - DB: SQL - OS: Windows 7

We can also use TEXT function of Excel using 3GL program. Here is the code...

In Excel :

In LN :
aloc = 31
chr$(061) & "text" & chr$(040) & str$(aloc) & chr$(044) & chr$(034) & "000" & chr$(034) & chr$(041) & " " &

Try this it will definitely work.
Reply With Quote
Sponsored Links
Old 9th May 2017, 10:06
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Join Date: Sep 2012
Location: India
Posts: 2,354
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Just this works fine as well -

test.f = "=" & chr$(34) & field.f & chr$(34)

You can write the variable to your CSV. That's it. Excel will handle the rest.


Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +2. The time now is 02:55.

©2001-2017 - -