如何获得Excel表格中各个Sheet的名字
如下,我是以ADO 方式打开的。请问在这种情况下如何获得Excel表格各个Sheet的名字?谢谢!
Public Sub connectADO()
'=========================
Dim sBasePath As String
GetUpFolder App.path, sBasePath
Set cn = New ADODB.Connection
With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=" & sBasePath & "TEXT\resource.xls;Extended Properties=Excel 8.0;"
.CursorLocation = adUseClient
.Open
End With
'=========================
End Sub