Set ex = CreateObject("Excel.Application") ex.ActiveWindow.SelectedSheets 在引用中添加EXCEL1.0就可以了
Dim newxls As Excel.Application Dim newbook As Excel.Workbook Dim newsheet As Excel.Worksheet Set newxls = CreateObject("Excel.Application") '创建excel应用程序,打开excel2000 newxls.Visible = True Set newbook = newxls.Workbooks.add '创建工作簿 Set newsheet = newbook.Worksheets(1) '创建工作表
加 microsoft excel x object libraryPrivate MyExcel As New Excel.Application MyExcel.Workbooks.Open App.Path & "\Book1.xls" eRows = MyExcel.Sheets(1).UsedRange.Rows.Count 'excel 的行數 eCols = MyExcel.Sheets(1).UsedRange.Columns.Count 'excel 的列數 ReDim c1(eRows) As String For i = 1 To eRows c1(i) = Trim(MyExcel.Worksheets(1).Cells(i, 1)) Next i
有一些关于Excel的示例。
你可以在搜索中输入“Excel”进行查找!
Set objexcel = New Excel.Application
objexcel.Visible = True
With objexcel.ActiveSheet
'此处放置控制EXCEL的代码
End with
ex.ActiveWindow.SelectedSheets
在引用中添加EXCEL1.0就可以了
Dim newbook As Excel.Workbook
Dim newsheet As Excel.Worksheet
Set newxls = CreateObject("Excel.Application") '创建excel应用程序,打开excel2000
newxls.Visible = True
Set newbook = newxls.Workbooks.add '创建工作簿
Set newsheet = newbook.Worksheets(1) '创建工作表
MyExcel.Workbooks.Open App.Path & "\Book1.xls"
eRows = MyExcel.Sheets(1).UsedRange.Rows.Count 'excel 的行數
eCols = MyExcel.Sheets(1).UsedRange.Columns.Count 'excel 的列數 ReDim c1(eRows) As String
For i = 1 To eRows
c1(i) = Trim(MyExcel.Worksheets(1).Cells(i, 1))
Next i