- 帖子
- 2798
- 主題
- 10
- 精華
- 0
- 積分
- 2854
- 點名
- 0
- 作業系統
- 〔略〕
- 軟體版本
- 〔略〕
- 閱讀權限
- 100
- 性別
- 男
- 來自
- 〔略〕
- 註冊時間
- 2013-5-13
- 最後登錄
- 2024-4-20
|
資料來源檔檔名不固定, 須手動開啟再執行程式:
Sub 複製()
Dim xB As Workbook, xU As Range, R&
Dim Sht As Worksheet, A, C%, xF As Range
Set Sht = Sheets("工作表1")
Sht.UsedRange.Offset(1, 0).EntireRow.Delete
'-------------------------------------
For Each xB In Workbooks
On Error Resume Next
If xB.Name = ThisWorkbook.Name Then GoTo 101
Set xU = xB.Sheets("Raw Data").UsedRange
R = xU.Rows.Count - 1
If Not xU Is Nothing Then Exit For
101: Next
On Error GoTo 0
If xU Is Nothing Then MsgBox "來源檔案未開啟! ": Exit Sub
If R = 0 Then MsgBox "來源檔案無資料! ": Exit Sub
'欄位::數量-號碼-名稱-日期
For Each A In Array("Total Qty", "no", "name", "date2")
C = C + 1
Set xF = xU.Rows(1).Find(A, Lookat:=xlWhole)
If Not xF Is Nothing Then xF(2).Resize(R).Copy Sht.Cells(2, C)
Next
End Sub
 XX001.rar (20.42 KB)
================================ |
|
發表於 2020-7-19 11:29
| 