Link to home
Start Free TrialLog in
Avatar of Wongy
WongyFlag for Belgium

asked on

Export from BusinessObjects to CSV

Hi,

I'd like to export a BusinessObjects report with VBA to CSV.

I can already do that with ConvertTo(boExpAsciiCSV,1,"File"), but the fields are not enclosed with double quotes. Which causes the problem that when some fields contain line breaks, they are considered as a new entry.

Thanx for your help.
Avatar of Wongy
Wongy
Flag of Belgium image

ASKER

Hi,

This is solved now.

I just enclose the fields by double quotes in the report itself, before exporting it to CSV.
My problem was that BoB would not concatenate the double quotes (") to the cells. So I did this: =Chr(34) & (cell content) & Chr(34)
and this works fine.

Thanx.
ASKER CERTIFIED SOLUTION
Avatar of kodiakbear
kodiakbear

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial