20 Apr 2007 發問 .........可悲的 版主 不看, 不回答 !!!! [em04] ------------------------------- 用 ADO 方法 , 請參考 Sub GetSheetNames() Dim CDLG As Object, ADOX As Object, TableName As String Set CDLG = CreateObject("MSComDlg.CommonDialog") Set ADOX = CreateObject("ADOX.Catalog") With CDLG .DialogTitle = "開啟檔案!" .Filter = _ "Excel File|*.xls" .ShowOpen dbFile = .Filename End With strProvider = "Driver={Microsoft Excel Driver (*.xls)}; DBQ=" & dbFile & ";" With ADOX .ActiveConnection = strProvider For i = 0 To .Tables.Count - 1 TableName = .Tables(i).Name If Right$(TableName, 1) = "$" Then MsgBox 工作表名稱:" & Left$(TableName, Len(TableName) - 1) End If Next i End With Set CDLG = Nothing Set ADOX = Nothing End Sub |