Dim xlApp As Excel.Application Dim xlworkBook As Excel.Workbook Dim xlsheet As Excel.Worksheetet xlApp = CreateObject("Excel.application") Set xlworkBook = xlApp.Workbooks.Open(strFilePath) Set xlsheet = xlworkBook.Worksheets(strSheet) xlworkBook.Close SaveChanges:=False Set xlworkBook = Nothing xlApp.Quit Set xlApp = Nothing
Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet set xlApp = CreateObject("Excel.application") Set xlworkBook = xlApp.Workbooks.Open(文件路径) Set xlSheet = xlBook.Sheets(1) '填入想要填入Excel中的内容 '如xlSheet.Cells(0,0) ="aaaaaa" xlSheet.Application.Visible = True xlBook.Windows(1).Visible = True xlBook.Save Set xlBook = Nothing
Dim xlworkBook As Excel.Workbook
Dim xlsheet As Excel.Worksheetet xlApp = CreateObject("Excel.application")
Set xlworkBook = xlApp.Workbooks.Open(strFilePath)
Set xlsheet = xlworkBook.Worksheets(strSheet)
xlworkBook.Close SaveChanges:=False
Set xlworkBook = Nothing
xlApp.Quit
Set xlApp = Nothing
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
set xlApp = CreateObject("Excel.application")
Set xlworkBook = xlApp.Workbooks.Open(文件路径)
Set xlSheet = xlBook.Sheets(1)
'填入想要填入Excel中的内容
'如xlSheet.Cells(0,0) ="aaaaaa"
xlSheet.Application.Visible = True
xlBook.Windows(1).Visible = True
xlBook.Save
Set xlBook = Nothing