Saya memakai Wind.vista tetapi setelah saya menginstal visual basic 6.0 saya malah mndapatkan error dengan pesan : Atomatic updates OLE registry. Kenapa Bisa begitu, padahal johan dah mau TA ni. Bantu Johan ya.
----- Forwarded Message ---- From: Nyom2 <[EMAIL PROTECTED]> To: [email protected] Sent: Friday, June 6, 2008 8:03:26 AM Subject: Re: [Programmer-VB] Format XLS->properti boder ??? Hello, Terimakasih atas share-nya . Salam, Nyom2 ----- Original Message ----- From: Katro Boy To: Programmer-VB@ yahoogroups. com Sent: Wednesday, June 04, 2008 4:08 PM Subject: Re: [Programmer- VB] Format XLS->properti boder ??? Bisa seperti ini: With vExcel.Worksheets( "Sheet1") Worksheets(" Sheet1"). Activate .Cells(1, 1).Value = "TEST": .Cells(1, 1).Font.Bold = True .Cells(2, 1).Value = "FORMAT BORDER EXCEL" .Cells(1, 2).Value = "XXXXX" .Cells(2, 2).Value = "YYY" .Range(.Cells( 1, 1), _ .Cells(2, 2)).Borders. LineStyle = xlHairline .Rows(1).RowHeight = 25 .Columns("A" ).ColumnWidth = 30 End With .vbp nya bisa didownload di Blog saya : http://katroboy. wordpress. com/ Thanks Nyom2 Denpasar wrote: > Maaf melanjutkan yg sebelumnya, saya sudah dapat link untuk memformat > cell Excel. Bila ada yg punya info, bagaimana memformat boder , > ketingguan rows, maupun lebar kolom ya.....di site tsb tidak ada, dan > saya cari2 di link yang lain belum menemukan. > > Tengkyu, ada yg punya referensi lain ?? > > salam, > nyom2 > ________________________________ No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.24.6/1480 - Release Date: 6/3/2008 7:00 AM
