- ©«¤l
- 36
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-2-20
- ³Ì«áµn¿ý
- 2015-3-6
|
¦^´_ 7# GBKEE
GBKEE ¤j¡G
·PÁ²M·¡ªº½d¨Ò¸Ñ¨M§ÚªºÆ[©À°ÝÃD §Ú¤]§Q¥Î³oÓ¤p¨Ò¤l§ïµ½§Úì¥ýªºµ{¦¡½X
½T¹ê¤w¸g¥i¥H°õ¦æ¤F ¸U¤À·PÁÂ
¥H¤U¤]¶K¤W§Úקï«áªºµ{¦¡½X Åý¦³»Ýnªº¤H¤]¥i¥H¾Ç²ß
¦pªG¯àÅýµ{¦¡½X§ó²¼äªº¸Ü ¤]½Ð¨ä¥L¤j¤j«ü±Ð
----------------------------------------------------------------------------------------------
Sub photoConv1()
Dim myFSO As New FileSystemObject
Dim myPath As String
Dim picNumRng As Range, myPic As Object
Dim myPhoto As String, countPhoto As String
Dim E As Variant
Dim i As Integer, j As Integer, k As Integer
myPath = ThisWorkbook.Path '½T»{¬¡¶Ã¯©Ò¦b¸ô®|
myPhoto = Dir(myPath & "\" & "ì©l¬Û¤ù" & "\" & "*.jpg") '¹Ï¤ùÀɸô®|
countPhoto = myFSO.GetFolder(myPath & "\" & "ì©l¬Û¤ù").Files.Count - 1 '¨ú±o¬Û¤ù¼Æ¶q
If myPhoto <> "" Then '¸ê®Æ§¨¤¤¦³¬Û¤ù®É½Æ»sªí®æ
j = 50
ActiveSheet.Cells(27, 3).Value = ActiveSheet.Cells(3, 3).Value
ActiveSheet.Cells(28, 7).Value = ActiveSheet.Cells(4, 7).Value
ActiveSheet.Cells(27, 7).Value = ActiveSheet.Cells(3, 7).Value
ActiveSheet.Cells(27, 8).Value = ActiveSheet.Cells(3, 8).Value
ActiveSheet.Cells(27, 10).Value = ActiveSheet.Cells(3, 10).Value
ActiveSheet.Cells(27, 12).Value = ActiveSheet.Cells(3, 12).Value
ActiveSheet.Cells(27, 14).Value = ActiveSheet.Cells(3, 14).Value
For i = 1 To ((countPhoto + 1) \ 2 - 1)
Rows("1:49").Copy '½Æ»sªí®æ
ActiveSheet.Paste Cells(j, 1)
j = j + 49
Next i
For k = 1 To countPhoto
Set picNumRng = Range("A" & (25 * (k - 1) + 5 - Application.WorksheetFunction.RoundUp((k - 1) / 2, 0)))
picNumRng = k '¿é¤J¬Û¤ù½s¸¹
For Each E In picNumRng
Set myPic = ActiveSheet.Pictures.Insert(myPath & "\" & "ì©l¬Û¤ù" & "\" & E & ".jpg") '´¡¤J»PÀx¦s®æ¦P¦Wªº¬Û¤ùÀÉ
With myPic
.ShapeRange.LockAspectRatio = msoFalse
.Top = picNumRng.Offset(0, 1).Top
.Left = picNumRng.Offset(0, 1).Left
.Width = picNumRng.Offset(0, 1).MergeArea.Width
.Height = picNumRng.Offset(0, 1).MergeArea.Height
End With
Next
Next k
Else
MsgBox "¸ê®Æ§¨¤¤¨S¦³¬Û¤ù"
End If
Set picNumRng = Nothing
Set myPic = Nothing
End Sub |
|