Re: Report Writer

If you write a text file character report & make sure that each column is delimited by a character EG column1;column2; then you can open up the text file in Excel & either create a macro that will import the text file using the semi-colon as a delimiter or user Excel's own builtin Import wizard & choose the semi-colon as a delimiter. Then each column will be in its individual cell in Excel.

Hope this helps...

Claire

Kasi wrote:
>
> Hello everone
>
> I'm trying to send output from one of my reports on to an excel file. It
>
> send's okay. But the problem is, I have 4 columns in my report and all
> of them appear on the same cell in the excel sheet. In my application I
> can't use csv file's either. Any suggesstions...
> Reply me at kskasi_at_hotmail.com
> Thanx in advance...kasi
Received on Tue Dec 07 1999 - 12:40:55 CET