- 帖子
- 4901
- 主題
- 44
- 精華
- 24
- 積分
- 4916
- 點名
- 196
- 作業系統
- Windows 7
- 軟體版本
- Office 20xx
- 閱讀權限
- 150
- 性別
- 男
- 來自
- 台北
- 註冊時間
- 2010-4-30
- 最後登錄
- 2025-8-11
               
|
回復 1# jackyliu
圖片命名規則不是很懂,先試試這樣看怎樣不同- Sub Ex()
- Dim A As Range, C As Range
- ar = Array("C", "F", "T")
- ay = Array(8, 9, 10)
- ak = Array("", 0, 1, 2, 3)
- fd = "C:\TEST\" '圖片目錄
- With Sheet1
- .Pictures.Delete
- For Each C In .Range(.[C3], .[C65536].End(xlUp))
- r = C.Row
- For i = 0 To 2
- For j = 0 To 3
- mystr = IIf(ak(j) = "", "", "-" & ak(j))
- fs = C & "-" & ar(i) & mystr & ".jpg"
- If Dir(fd & fs) <> "" Then
- Set A = .Cells(r, IIf(j = 0, ay(i), 10 + j))
- With .Pictures.Insert(fd & fs)
- .Top = A.Top: .Left = A.Left: .Height = A.Height: .Width = A.Width
- End With
- End If
- Next
- Next
- Next
- End With
- End Sub
複製代碼 |
|