以下是全部代码: Dim xlApp As Excel.Application Dim x1Book As Excel.Workbook Dim x1Sheet As Excel.Worksheet Set xlApp = CreateObject("Excel.Application") '创建EXCEL应用类 xlApp.Visible = True '设置EXCEL可见 Set xlBook = xlApp.Workbooks.Open(App.Path & "\有金额.xls") '打开EXCEL工作簿 Set xlSheet = xlBook.Worksheets(1) '打开EXCEL工作表 xlSheet.Activate '激活工作表
用 set xlApp =new Excel.Application set x1Book = Excel.Workbook.add() set x1Sheet = Excel.Worksheets("sheet1") xlApp.Range("A1").value="abc" 试试,我这里是vb6.0
哦,好了 但是怎么关闭打开的EXCEL对象啊?
Set Aexcel = New Excel.Application Set aWbook = Aexcel.Workbooks.Add Set Asheet = Aexcel.Sheets(1)
Aexcel.Visible = False ………… Aexcel.Quit
Set Asheet = Nothing Set aWbook = Nothing Set Aexcel = Nothing
set x1book = .....
Dim x1Book As Excel.Workbook
Dim x1Sheet As Excel.Worksheet Set xlApp = CreateObject("Excel.Application") '创建EXCEL应用类
xlApp.Visible = True '设置EXCEL可见
Set xlBook = xlApp.Workbooks.Open(App.Path & "\有金额.xls") '打开EXCEL工作簿
Set xlSheet = xlBook.Worksheets(1) '打开EXCEL工作表
xlSheet.Activate '激活工作表
xlSheet.Cells(1, 1) = "abc" '给单元格1行驶列赋值
xlApp.Save App.Path & "\test.xls"
set xlApp =new Excel.Application
set x1Book = Excel.Workbook.add()
set x1Sheet = Excel.Worksheets("sheet1")
xlApp.Range("A1").value="abc"
试试,我这里是vb6.0
但是怎么关闭打开的EXCEL对象啊?
Set aWbook = Aexcel.Workbooks.Add
Set Asheet = Aexcel.Sheets(1)
Aexcel.Visible = False …………
Aexcel.Quit
Set Asheet = Nothing
Set aWbook = Nothing
Set Aexcel = Nothing