|
原帖由 ngcg 于 2010-8-28 18:11 发表
请版主提供明确的实例以供参考。谢谢。
论坛上比比皆是。
我示例一下,仅供理解。
Option Explicit
Sub Example_AddReference()
'''VBE 引用Microsoft Excel 11.0 Object Library
Dim xlApp As New Excel.Application
Dim xlWBK As Excel.Workbook
Dim xlSht As Excel.Worksheet
Dim xlRng As Excel.Range
Dim C As Excel.Range
Set xlWBK = xlApp.Workbooks.Open("D:\Temp\sample.xls")
Set xlSht = xlWBK.Worksheets(1)
With xlSht
Set xlRng = .Range(.Cells(1, 1), .Cells(65536, 1).End(xlUp))
End With
For Each C In xlRng
Debug.Print C.Value
Next
xlWBK.Close False
Set xlWBK = Nothing
xlApp.Quit
Set xlApp = Nothing
End Sub
Sub Example_CreateObject()
Dim xlApp As Object
Dim xlWBK As Object
Dim xlSht As Object
Dim xlRng As Object
Dim C As Object
Set xlApp = CreateObject("Excel.Application")
Set xlWBK = xlApp.Workbooks.Open("D:\Temp\sample.xls")
Set xlSht = xlWBK.Worksheets(1)
With xlSht
Set xlRng = .Range(.Cells(1, 1), .Cells(65536, 1).End(-4162))
End With
For Each C In xlRng
Debug.Print C.Value
Next
xlWBK.Close False
Set xlWBK = Nothing
xlApp.Quit
Set xlApp = Nothing
End Sub
''''前者为前期绑定,即在VBE中勾选对于MS EXCEL 库的引用;后期为后期绑定,使用CreateObject创建一个已注册的库的类的实例。
'''前者如果开发机上引用为高版本时(如12.0),在低端用户机上(如11.0)时将发生引用丢失现象,反之则不会出现。但后期绑定时则不存在此问题,CreateObject时总是创建一个当前环境下已注册的类的实例。 |
|