DEAR ALL ¤j¤j
1.¹Ï¤@µ{¦¡·|Âà¦sCells(i, 3)¹ÏÀÉ¦Ü \pcbfs02\C701\¥Í²£«ü¥Ü¥d¹ÏÀÉ\ ¤UÀɮצWºÙ 00 01 02 03.....
2.¦p¦óÅýÀɮצWºÙ§ï¬° Cells(i, 1)+Cells(i, 2) Àx¦s®æ¤º®e
2.1 p.Name = Format(j, "00") & ".jpg" ¦p¦ó×q
3.·Ð¤£§[½ç±Ð THANKS*10000
¹Ï¤@
Sub yy()
Dim j%
Application.ScreenUpdating = False
For i = 2 To [a65536].End(xlUp).Row
For Each p In ActiveSheet.Shapes
If Not Application.Intersect(p.TopLeftCell, Cells(i, 3)) Is Nothing Then
p.Name = Format(j, "00") & ".jpg"
p.CopyPicture
ActiveSheet.Paste
With ActiveSheet.ChartObjects.Add(300, 0, Selection.Width, Selection.Height).Chart
.Paste
.Export "\\pcbfs02\C701\¥Í²£«ü¥Ü¥d¹ÏÀÉ\" & p.Name, "JPG"
Selection.Delete
.Parent.Delete
End With
Application.ScreenUpdating = True
j = j + 1
End If
Next p
Next i
End Sub |