|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
请测试代码:
- Sub 批量导入相片jpj123()
- Dim i, myPath$, a1, a2, b1, b2, n%
- Dim Pa As Picture, FD As FileDialog
- n = Sheets("Sheet1").Range("A65536").End(3).Row
- Set FD = Application.FileDialog(msoFileDialogFolderPicker)
- If FD.Show = -1 Then myPath = FD.SelectedItems(1) & ""
- 'myPath = ThisWorkbook.Path & "" '获取当前文件的路径
- Application.ScreenUpdating = False
- For Each Pa In ActiveSheet.Pictures
- Pa.Delete
- Next
- On Error GoTo X
- For i = 2 To n
- a1 = 0: a2 = 0: b1 = 0: b2 = 0
- Range("C" & i).Select
- a1 = ActiveCell.Left
- a2 = ActiveCell.Top
- b1 = ActiveCell.Width
- b2 = ActiveCell.Height
- ActiveSheet.Pictures.Insert(myPath & Range("A" & i).Value & ".jpg").Select
- Selection.ShapeRange.LockAspectRatio = False
- Selection.ShapeRange.Left = a1 + 1
- Selection.ShapeRange.Top = a2 + 1
- Selection.ShapeRange.Width = b1 - 2
- Selection.ShapeRange.Height = b2 - 2
- X:
- Next i
- Application.ScreenUpdating = True
- MsgBox "完成!"
- End Sub
复制代码 |
|