Wongy
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.
I'd like to export a BusinessObjects report with VBA to CSV.
I can already do that with ConvertTo(boExpAsciiCSV,1,
Thanx for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.