Hi Cecil,
You can have look at my rep2excel tools here in downloads
Download#
14800It is made exactly for this kind of things.
It is basically automated Excel OLE automation, letting you manipulate excel file as 3d array. So writing excel comes as easy as ;
.
oXL.make_cell(i,j,k,'Hello')
oXL.table_in_section(i,j,k,'MyAlias',cScanForClause)
oXL.array_in_section(i,j,k,@MyArray)
oXL.draw_box(nTop,nLeft,nDown,nRight)
.
etc
Hope it helps you do your thing.
Rgds++
Sergio
>I forgot to mention that this will be written in VFP 6.0, since the machine we are putting this prgoram on is a Windows 95 machine. So, I had to eliminate the LOCAL ox1 AS "Excel.Application" and use only LOCAL ox1. Then that presents a problem when I use oExcel.Visible = .T.