vb excel编程有关问题
vb excel编程问题。
sheetOut.Range(Cells(1, 1), Cells(1, 7)).Merge
这行代码在第一次运行时,正常。
运行第二次时,报错,“应用程序定义或对象定义错误”,怎么回事?
Dim excelOut As New Excel.Application
Dim workbookOut As New Excel.Workbook
Dim sheetOut As New Excel.Worksheet
excelOut.Visible = True
excelOut.SheetsInNewWorkbook = 1
Set workbookOut = excelOut.Workbooks.Add
Set sheetOut = workbookOut.Worksheets(1)
sheetOut.Range(Cells(1, 1), Cells(1, 7)).Merge
完毕。
------解决方案--------------------
可能在释放中有问题,两个可能不太一样吧
------解决方案--------------------
sheetOut.Range(Cells(1, 1), Cells(1, 7)).Merge
改成
sheetOut.Range(sheetOut.Cells(1, 1), sheetOut.Cells(1, 7)).Merge
------解决方案--------------------
Dim excelOut As New Excel.Application
Dim workbookOut As New Excel.Workbook
Dim sheetOut As New Excel.Worksheet
excelOut.Visible = True
excelOut.SheetsInNewWorkbook = 1
Set workbookOut = excelOut.Workbooks.Add
Set sheetOut = workbookOut.Worksheets(1)
sheetOut.Range(Cells(1, 1), Cells(1, 7)).Merge
第一次运行焦点存在 第二次运行sheet失去焦点 Cells(1, 7) 与 sheetOut指向出现错误
------解决方案--------------------
sheetOut.Range(sheetOut.Cells(1, 1), sheetOut.Cells(1, 7)).Merge
sheetOut.Range(Cells(1, 1), Cells(1, 7)).Merge
这行代码在第一次运行时,正常。
运行第二次时,报错,“应用程序定义或对象定义错误”,怎么回事?
Dim excelOut As New Excel.Application
Dim workbookOut As New Excel.Workbook
Dim sheetOut As New Excel.Worksheet
excelOut.Visible = True
excelOut.SheetsInNewWorkbook = 1
Set workbookOut = excelOut.Workbooks.Add
Set sheetOut = workbookOut.Worksheets(1)
sheetOut.Range(Cells(1, 1), Cells(1, 7)).Merge
完毕。
------解决方案--------------------
可能在释放中有问题,两个可能不太一样吧
------解决方案--------------------
sheetOut.Range(Cells(1, 1), Cells(1, 7)).Merge
改成
sheetOut.Range(sheetOut.Cells(1, 1), sheetOut.Cells(1, 7)).Merge
------解决方案--------------------
Dim excelOut As New Excel.Application
Dim workbookOut As New Excel.Workbook
Dim sheetOut As New Excel.Worksheet
excelOut.Visible = True
excelOut.SheetsInNewWorkbook = 1
Set workbookOut = excelOut.Workbooks.Add
Set sheetOut = workbookOut.Worksheets(1)
sheetOut.Range(Cells(1, 1), Cells(1, 7)).Merge
第一次运行焦点存在 第二次运行sheet失去焦点 Cells(1, 7) 与 sheetOut指向出现错误
------解决方案--------------------
sheetOut.Range(sheetOut.Cells(1, 1), sheetOut.Cells(1, 7)).Merge