本帖最后由 爱疯 于 2016-5-9 15:06 编辑
Sub liang()
mapth = "d:\2016年春版女单图片\"
f = Dir(mapth & "*.jpg")
While f <> ""
k = k + 1
Cells(k, 1) = f
f = Dir
Wend
For x = 1 To Range("a65536").End(3).Row
If Cells(x, 1) <> "" Then ActiveSheet.Hyperlinks.Add anchor:=Cells(x, 1), Address:=mapth & Cells(x, 1)
Next
End Sub
颜色是修改过的地方,也可写成下面这样。
Sub liang()
p = "d:\2\"
f = Dir(p & "*.jpg")
While f <> ""
i = i + 1
Cells(i, 1) = f
ActiveSheet.Hyperlinks.Add Anchor:=Cells(i, 1), Address:=p & f
f = Dir
Wend
End Sub