'以下代码仅供参考 Option ExplicitPrivate Sub Command1_Click() Dim xlsApp As Excel.Application Dim xlsDataBook As Excel.Workbook Dim xlsDataSheetD As Excel.Worksheet Set xlsApp = New Excel.Application Set xlsDataBook = xlsApp.Workbooks.Open(txtDataSheet.Text) Set xlsDataSheetD = xlsDataBook.Sheets("ABC") xlsDataBook.Sheets("ABC").Select '打开book1中指定的ABC表 xlsApp.Visible = false '/////////////////////////////////////////////////////////////// xlsDataSheetD.Activate '这个地方自己改,要有写ABC表的办法,因为没有显示Excel表,你是在暗地里写ABC表 'xlsDataSheetD.Range(Cells(3, 1), Cells(3, 3)).Copy xlsDataBook.Save '////////////////////////////////////////////////////////////////// xlsDataBook.Close Set xlsDataSheetD = Nothing Set xlsDataBook = Nothing xlsApp.Quit Set xlsApp = Nothing End Sub
Option ExplicitPrivate Sub Command1_Click()
Dim xlsApp As Excel.Application
Dim xlsDataBook As Excel.Workbook
Dim xlsDataSheetD As Excel.Worksheet
Set xlsApp = New Excel.Application
Set xlsDataBook = xlsApp.Workbooks.Open(txtDataSheet.Text)
Set xlsDataSheetD = xlsDataBook.Sheets("ABC")
xlsDataBook.Sheets("ABC").Select '打开book1中指定的ABC表
xlsApp.Visible = false
'///////////////////////////////////////////////////////////////
xlsDataSheetD.Activate
'这个地方自己改,要有写ABC表的办法,因为没有显示Excel表,你是在暗地里写ABC表
'xlsDataSheetD.Range(Cells(3, 1), Cells(3, 3)).Copy
xlsDataBook.Save
'//////////////////////////////////////////////////////////////////
xlsDataBook.Close
Set xlsDataSheetD = Nothing
Set xlsDataBook = Nothing
xlsApp.Quit
Set xlsApp = Nothing
End Sub