代码如下:Dim Excelapp As New excel.Application
Excelapp.Workbooks.AddDim i, j As Long
For i = 0 To MSHFlexGrid1.Rows - 1
For j = 2 To MSHFlexGrid1.Cols - 1
If j = 2 Then
Excelapp.Cells(i + 1, j - 1) = Chr(13) & MSHFlexGrid1.TextMatrix(i, j)
Else
Excelapp.Cells(i + 1, j - 1) = MSHFlexGrid1.TextMatrix(i, j)
End If
Next
Next
Excelapp.Columns.AutoFitOn Error GoTo ert
Excelapp.SaveWorkspace
ert:
Excelapp.Quit
在Excelapp.SaveWorkspace保存后,除了要存的一个.xls文件,还多出一个RESUME.XLW文件???
如何不让RESUME.XLW文件出现?
Excelapp.Workbooks.AddDim i, j As Long
For i = 0 To MSHFlexGrid1.Rows - 1
For j = 2 To MSHFlexGrid1.Cols - 1
If j = 2 Then
Excelapp.Cells(i + 1, j - 1) = Chr(13) & MSHFlexGrid1.TextMatrix(i, j)
Else
Excelapp.Cells(i + 1, j - 1) = MSHFlexGrid1.TextMatrix(i, j)
End If
Next
Next
Excelapp.Columns.AutoFitOn Error GoTo ert
Excelapp.SaveWorkspace
ert:
Excelapp.Quit
在Excelapp.SaveWorkspace保存后,除了要存的一个.xls文件,还多出一个RESUME.XLW文件???
如何不让RESUME.XLW文件出现?
Excelapp.Cells(i + 1, j - 1)这个能运行是由于默认属性(默认二次了)
Workbook可以SaveAsExcelapp.ActiveWorkbook.SaveAs "c:\test.xls"