vb中导入资料到excel中如果报表页数超过6页就打不开导出的excel文件。
错误信息为:"不能读取文件"
导出的代码:
'========================================================================================
'=导出为ExCel文档
'========================================================================================
Private Sub TolExecl()
Dim myexportobject As New ActiveReportsExcelExport.ARExportExcel
On Error GoTo Errh
Cmndlg.DialogTitle = "保存报表文件"
Cmndlg.InitDir = "C:\My Documents"
Cmndlg.filter = "Excel(*.xls)|*.xls"
Cmndlg.ShowSave
If Cmndlg.CancelError Then Exit Sub
myexportobject.FileName = Cmndlg.FileName
myexportobject.TrimEmptySpace = True
myexportobject.GenPagebreaks = True
myexportobject.ShowMarginSpace = True
myexportobject.Export ARV.Pages
Set myexportobject = Nothing
Exit Sub
Errh:
Call GSG_Err.ErrUpdate(Me.Caption & "/TolExecl", Err.Number, Err.Description & "/" & Err.Source)
Err.Clear
Exit Sub
End Sub
错误信息为:"不能读取文件"
导出的代码:
'========================================================================================
'=导出为ExCel文档
'========================================================================================
Private Sub TolExecl()
Dim myexportobject As New ActiveReportsExcelExport.ARExportExcel
On Error GoTo Errh
Cmndlg.DialogTitle = "保存报表文件"
Cmndlg.InitDir = "C:\My Documents"
Cmndlg.filter = "Excel(*.xls)|*.xls"
Cmndlg.ShowSave
If Cmndlg.CancelError Then Exit Sub
myexportobject.FileName = Cmndlg.FileName
myexportobject.TrimEmptySpace = True
myexportobject.GenPagebreaks = True
myexportobject.ShowMarginSpace = True
myexportobject.Export ARV.Pages
Set myexportobject = Nothing
Exit Sub
Errh:
Call GSG_Err.ErrUpdate(Me.Caption & "/TolExecl", Err.Number, Err.Description & "/" & Err.Source)
Err.Clear
Exit Sub
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货