ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦ó±Nfile§¨¹ÏÀɤ@¦¸¥þ³¡±a¤Jexcelªí®æ¸Ì

¦p¦ó±N¹Ï¤ùÀɶפJEXCEL¨î©w®æ¦¡¤º

°²³]§Ú¦³¤@­ÓFile¸Ì¦³20±i¹ÏÀɩΪ̧ó¦h~
µM«á§Ú¦bexcel¸Ì³]©w20­Ó©Î§ó¦hªº¨î¦¡ªí®æ~
§Ú­n¦p¦ó¼g¤p¥¨¶°©Î¨ä¥L¤è¦¡¡A´N¥i¥H¦Û°Ê±Nfileªº¹Ï¤ùÀɶפJ³o­Ó¨î¦¡ªí®æ¸Ì
¦³­þ¦ì°ª°ª¤â¥i¥HÀ°§Ú¸Ñµª¤@¤U?«D±`ªº·PÁÂ!

123.jpg (165 KB)

123.jpg

TOP

½Ð¦U¦ì°ª°ª¤âÀ°¦£¤p§Ì¤@¤Uªü~!!!
·PÁÂ~

TOP

¤p§Ì¦³§ä¨ì¤@½g¤峹¡A¦ý³o½g¤å³¹ªºµ{¦¡½X¥D­n¬O±N·Ó¤ù©ñ¦b¦P¤@Äæ¡A¦WºÙ¦b¥t¥~¤@Äæ
¤p§Ì±N©Ò»Ýªº¹Ï¤ùÀɮ׳£©ñ¸m D:/TEST ¸Ì­±
«ö¥¨¶°=>¹Ï¤ù¨Ì§Ç¶K¤WBÄ檺Àx¦s®æ µM«á  CÄæ¨Ì§ÇÅã¥Ü¥XÀɦW
¦ý¤p§Ì·Q½Ð±Ð¤j®a­n§ï¬°=>¹Ï¤ù¨Ì§Ç¦bA1Äæ¦WºÙ ->B1Äæ¹Ï¤ù->C1Äd¦WºÙ->D1Äæ¹Ï¤ù   µM«á¦b±Æ¦^A2Äæ¦WºÙ ->B2Äæ¹Ï¤ù->C2Äd¦WºÙ->D2Äæ¹Ï¤ù ...........
½Ð°Ý¦U¦ì°ª¤â¨Ì·Ó¤U­±µ{¦¡½X¥i¥H§ï¬°§Ú¤W­±ªº»Ý¨D?
·PÁ¤j®a~
  1. Sub PHOTO()
  2. ActiveSheet.Columns("C") = ""
  3. Set Sh = ActiveSheet
  4. With Sh
  5.     .Pictures.Delete
  6. End With
  7. fs = Dir("D:\TEST\*.jpg")
  8. Do Until fs = ""
  9.    R = R + 1
  10.    Cells(R, 3) = fs
  11.    Cells(R, 2).Select
  12.    ActiveSheet.Pictures.Insert("D:\TEST\" & Cells(R, 3)).Select
  13.    With Selection
  14.        .Top = ActiveSheet.Cells(R, 2).Top + 1
  15.        .Left = ActiveSheet.Cells(R, 2).Left + 1
  16.        .Width = ActiveSheet.Cells(R, 2).Width - 1
  17.        .Height = ActiveSheet.Cells(R, 2).Height - 1
  18.    End With
  19.    fs = Dir
  20. Loop
  21. End Sub
½Æ»s¥N½X

TOP

[µo°Ý] ¦p¦ó±Nfile§¨¹ÏÀɤ@¦¸¥þ³¡±a¤Jexcelªí®æ¸Ì

¤p§Ì¦³§ä¨ì¤@½g¤峹¡A¦ý³o½g¤å³¹ªºµ{¦¡½X¥D­n¬O±N·Ó¤ù©ñ¦b¦P¤@Äæ¡A¦WºÙ¦b¥t¥~¤@Äæ
¤p§Ì±N©Ò»Ýªº¹Ï¤ùÀɮ׳£©ñ¸m D:/TEST ¸Ì­±
«ö¥¨¶°=>¹Ï¤ù¨Ì§Ç¶K¤WBÄ檺Àx¦s®æ µM«á  CÄæ¨Ì§ÇÅã¥Ü¥XÀɦW
¦ý¤p§Ì·Q½Ð±Ð¤j®a­n§ï¬°=>¹Ï¤ù¨Ì§Ç¦bA1Äæ¦WºÙ ->B1Äæ¹Ï¤ù->C1Äd¦WºÙ->D1Äæ¹Ï¤ù   µM«á¦b±Æ¦^A2Äæ¦WºÙ ->B2Äæ¹Ï¤ù->C2Äd¦WºÙ->D2Äæ¹Ï¤ù ...........
½Ð°Ý¦U¦ì°ª¤â¨Ì·Ó¤U­±µ{¦¡½X¥i¥H§ï¬°§Ú¤W­±ªº»Ý¨D?
·PÁ¤j®a~
  1. Sub PHOTO()
  2. ActiveSheet.Columns("C") = ""
  3. Set Sh = ActiveSheet
  4. With Sh
  5.     .Pictures.Delete
  6. End With
  7. fs = Dir("D:\TEST\*.jpg")
  8. Do Until fs = ""
  9.    R = R + 1
  10.    Cells(R, 3) = fs
  11.    Cells(R, 2).Select
  12.    ActiveSheet.Pictures.Insert("D:\TEST\" & Cells(R, 3)).Select
  13.    With Selection
  14.        .Top = ActiveSheet.Cells(R, 2).Top + 1
  15.        .Left = ActiveSheet.Cells(R, 2).Left + 1
  16.        .Width = ActiveSheet.Cells(R, 2).Width - 1
  17.        .Height = ActiveSheet.Cells(R, 2).Height - 1
  18.    End With
  19.    fs = Dir
  20. Loop
  21. End Sub
½Æ»s¥N½X

¥»©«³Ì«á¥Ñ GBKEE ©ó 2014-6-1 20:28 ½s¿è

¦^´_ 4# jaga0828
¸Õ¸Õ¬Ý
  1. Option Explicit
  2. Sub Ex()
  3.     Dim AR(), i As Integer, ii As Integer, fs As String, Rng As Range
  4.     With ActiveSheet
  5.         .Cells = ""
  6.         .Pictures.Delete
  7.         fs = Dir("D:\test\*.jpg")
  8.         Do Until fs = ""
  9.             ReDim Preserve AR(0 To i)
  10.             AR(i) = fs  '¹Ï¤ù¦WºÙ¸m¤J°}¦C
  11.             fs = Dir
  12.             i = i + 1
  13.         Loop
  14.         For i = 0 To UBound(AR) Step 2
  15.             For ii = 0 To 1
  16.                 If ii + i <= UBound(AR) Then
  17.                     .Cells(Int(i / 2) + 1, 1 + (ii * 2)) = AR(ii + i)
  18.                     Set Rng = .Cells(Int(i / 2) + 1, 2 + (ii * 2))
  19.                     With .Pictures.Insert("D:\test\" & AR(ii + i))
  20.                         .Top = Rng.Top
  21.                         .Left = Rng.Left
  22.                         .Width = Rng.Width
  23.                         .Height = Rng.Height
  24.                 End With
  25.                 End If
  26.             Next
  27.         Next
  28.     End With
  29. End Sub
½Æ»s¥N½X
  1. Sub Ex_1()
  2.     Dim f As Object, E As Object, Rng As Range, i  As Integer
  3.     Set f = CreateObject("Scripting.FileSystemObject").getfolder("D:\test").Files
  4.     With ActiveSheet
  5.         .Cells = ""
  6.         .Pictures.Delete
  7.         i = 1
  8.         For Each E In f
  9.             If LCase(E) Like "*.jpg" Then
  10.                 If i Mod 2 > 0 Then
  11.                     Set Rng = .Cells(Int(i / 2) + 1, 1)
  12.                 Else
  13.                     Set Rng = .Cells(i - Int(i / 2), 3)
  14.                 End If
  15.                 Rng.Value = E
  16.                 With .Pictures.Insert(E)
  17.                     .Top = Rng.Cells(1, 2).Top
  18.                     .Left = Rng.Cells(1, 2).Left
  19.                     .Width = Rng.Cells(1, 2).Width
  20.                     .Height = Rng.Cells(1, 2).Height
  21.                 End With
  22.                 i = i + 1
  23.             End If
  24.         Next
  25.     End With
  26. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

·PÁÂGBKEE¤j¤jªºÀ°¦£! ³o¸Ì°ª¤â¯uªº«Ü¼F®`¡A¯¬ºÝ¤È¨Î¸`´r§Ö~

TOP

GBKEE¤j¤j ±z¦n~~
¦n¹³²Ä¤G¬qªº°õ¦æ®É·|¸õ¥X µLªk¨ú±o Pic ªº insert ÄÝ©Ê¡H
¤£ª¾«ç»ò¸Ñ¨M©O¡H

TOP

GBKEE  ¤j..

§Úµo²{¨ì  ­ì¨Ó­ìPO ªº²Ä¤T©«´N¬O±µªñ§Ú·Q­nªº¥\¯à¤F..
¦]¬°§Ú¥­±`¥Îªº´N¬O Ãþ¦ü³o¼Ë..

¥u¬O·Q­nª¾¹Dªº¬O§_¦³¿ìªk¦A¼W¶i¬°

1¡B¥i¨q¥X¤¤¤åÀɦW

2¡B¸Ó¸ê®Æ§¨ªº¹ÏÀɳ£¤@¦¸PO¤W  (³o­Ó½d¨Ò§Ú­è¸Õ¹L.. ¤£ª¾¬°¦ó´N¬OµLªk§â D:\Test ¤¤ªº¥þ³¡³£¥á¤J ?? )

3¡B¹ÏÀÉÄÝ©Ê ¦Û°ÊÅܬ° "¤j¤p¦ì¸mÀHÀx¦s®æ¦ÓÅÜ"  
¦]¬°³o³¡¥÷¦pªG§Ñ°O§ïªº¸Ü~~°õ¦æ¤F¿z¿ï¥\¯à«á¡A¹Ï¸ò­ì¥»¥k¤è¬Û¹ïÀ³ªº¼Æ­È¡B¤å¦r·|¿ù¶Ã
¬O§_¦³§ó¤è«Kªº¤è¦¡¯à¸Ñ¨M©O¡H
  1. Sub PHOTO()
  2. ActiveSheet.Columns("C") = ""
  3. Set Sh = ActiveSheet
  4. With Sh
  5.     .Pictures.Delete
  6. End With
  7. fs = Dir("D:\TEST\*.jpg")
  8. Do Until fs = ""
  9.    R = R + 1
  10.    Cells(R, 3) = fs
  11.    Cells(R, 2).Select
  12.    ActiveSheet.Pictures.Insert("D:\TEST\" & Cells(R, 3)).Select
  13.    With Selection
  14.        .Top = ActiveSheet.Cells(R, 2).Top + 1
  15.        .Left = ActiveSheet.Cells(R, 2).Left + 1
  16.        .Width = ActiveSheet.Cells(R, 2).Width - 1
  17.        .Height = ActiveSheet.Cells(R, 2).Height - 1
  18.    End With
  19.    fs = Dir
  20. Loop
  21. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD