Klo sih,dr reportnya di export dulu ke text, trus jalanin prog excel trus file
teks itu di buka pake excel, nanti ada panduan utk menentukan pembagian kolom
dll.
Gunawan <[EMAIL PROTECTED]> wrote: Kalau tulis
langsung ke excel bagaimana?
gak usah export dari reportnya.
Cuma, harus ada excel terinstall di compie client sih
Set xls = New Excel.Application
xls.Visible = True
xls.Workbooks.Add
Set wb = xls.ActiveWorkbook
Set ws = wb.ActiveSheet
ws.Name = "RPT" + Format(Now(), "dd-mmm-yy")
ws.Range("A7", "AB7").Interior.ColorIndex = colHeader
ws.Cells(7, 1) = "Kode Barang"
----- Original Message -----
From: "**Agus Sudana**" <[EMAIL PROTECTED]>
To: "milis programmer" <[email protected]>
Sent: Tuesday, June 05, 2007 12:42 PM
Subject: [Programmer-VB] agar CR export ke Excel rapi
> dear all,
> agar hasil export dari cristal report 8.5 ke microsoft excel lebih rapi,
> kira2 ada triknya atau ada komponen-nya gak..?
> karena, sewaktu di export ke excel, di file excelnya, antara row record 1
> dan ke-2 ada diberi row kosong dan seterusnya.
>
> terima kasih,
> regards,
> (\__/)
> (='.'=) Agus Sudana
> (")_(")
>
>
>
>
>
>
>
> __________________________________________________________
> Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user
> panel and lay it on us.
> http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
>
---------------------------------
Building a website is a piece of cake.
Yahoo! Small Business gives you all the tools to get online.
