Can you use a different format? Try CSV, and see what happens in Excel when you try to open the file... This coding use for more than 655356 coding Excel VBA ============= Sub ExcelRepGenerate(doc As busobj.Document, ByVal FileName As String) ... Set rep = doc.ActiveReport OrigName = rep.Name FileName = FileName & "\default.xls" x = rep.ExportAsText(FileName) .. End Sub or u can search in http://www.forumtopics.com/busobj/viewtopic.php?t=17533&highlight=65536 hope this answer can help
--- On Tue, 11/11/08, Harry siswanto <[EMAIL PROTECTED]> wrote: From: Harry siswanto <[EMAIL PROTECTED]> Subject: [belajar-access] OOT: Excel morethan 65535 To: "belajar-access" <[email protected]> Date: Tuesday, November 11, 2008, 6:22 PM dear all How to set Row in Excel, for more than 65535 Rows??? regards
