- 帖子
- 3
- 主題
- 0
- 精華
- 0
- 積分
- 10
- 點名
- 0
- 作業系統
- windows 10
- 軟體版本
- 2018
- 閱讀權限
- 10
- 性別
- 男
- 註冊時間
- 2023-1-18
- 最後登錄
- 2024-4-19
|
我是這樣用的
Dim TPP(300, 2) As String
Dim myFolder1 As String, myFile1 As String
myFolder1 = "D:\查詢用資料庫\"
myFile1 = Dir(myFolder1) ‘指定目錄
J = 0
Do While myFile1 <> ""
If myFile1 Like "*.xlsm" Or myFile2 Like "*.XLSM" Then
TPP(M, 0) = "舊版"
TPP(M, 1) = myFile1
TPP(M, 2) = " D:\查詢用資料庫\" & myFile1
M = M + 1
End If
myFile1 = Dir()
J = J + 1
Loop
List_item.List() = TPP ‘List_item 為列表物件 |
|