Dim objExl As Excel.Application '声明对象变量
Dim i As Long
Dim j As Long
Dim x As Long
Set objExl = New Excel.Application '初始化对象变量
objExl.SheetsInNewWorkbook = 1 '将新建的工作薄数量设为1
objExl.Workbooks.Add '增加一个工作薄
objExl.Sheets(objExl.Sheets.Count).Name = "book1" '修改工作薄名称
objExl.Sheets("book1").Select
i = 1: j = 1
For x = 1 To 1000
objExl.Cells(i, j).Value = x
j = j + 1
If j = 20 Then j = 1: i = i + 1
NextobjExl.Application.IgnoreRemoteRequests = False
objExl.Visible = True '使EXCEL可见
objExl.Application.WindowState = xlMaximized 'EXCEL的显示方式为最大化
objExl.ActiveWindow.WindowState = xlMaximized '工作薄显示方式为最大化
Set objExl = Nothing '清除对象
在C2.2/512M的机子上打开一次需要10秒钟时间…
Dim i As Long
Dim j As Long
Dim x As Long
Set objExl = New Excel.Application '初始化对象变量
objExl.SheetsInNewWorkbook = 1 '将新建的工作薄数量设为1
objExl.Workbooks.Add '增加一个工作薄
objExl.Sheets(objExl.Sheets.Count).Name = "book1" '修改工作薄名称
objExl.Sheets("book1").Select
i = 1: j = 1
For x = 1 To 1000
objExl.Cells(i, j).Value = x
j = j + 1
If j = 20 Then j = 1: i = i + 1
NextobjExl.Application.IgnoreRemoteRequests = False
objExl.Visible = True '使EXCEL可见
objExl.Application.WindowState = xlMaximized 'EXCEL的显示方式为最大化
objExl.ActiveWindow.WindowState = xlMaximized '工作薄显示方式为最大化
Set objExl = Nothing '清除对象
在C2.2/512M的机子上打开一次需要10秒钟时间…
如果用VB自带的报表只要2、3秒就可以了