- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¥»©«³Ì«á¥Ñ GBKEE ©ó 2012-4-5 13:42 ½s¿è
¦^´_ 1# luke - Option Explicit
- Sub «Ø¥ß()
- Dim Rng As Range, xF As Variant, xlDesktop As String
- Set Rng = Range("A7:A" & [A7].End(xlDown).Row)
- Set xF = Rng.Find([b1], lookat:=xlWhole)
- If xF Is Nothing Then Exit Sub
- xF = Application.Transpose(Application.Transpose(Cells(xF.Row, "a").Resize(, 3).Value))
- xF = Join(xF, "-") & "-" & Format(Date, "yymmdd")
- xlDesktop = Get_Desktop
- If Dir(xlDesktop & xF, 16) = "" Then MkDir (xlDesktop & xF) '
- End Sub
- Sub ¥þ¿ï()
- Dim E As Range, xF As Variant, xlDesktop As String
- xlDesktop = Get_Desktop
- For Each E In Range("A7:A" & [A7].End(xlDown).Row)
- xF = Application.Transpose(Application.Transpose(Cells(E.Row, "a").Resize(, 3).Value))
- xF = Join(xF, "-") & "-" & Format(Date, "yymmdd")
- If Dir(xlDesktop & xF, 16) = "" Then MkDir (xlDesktop & xF)
- Next
- End Sub
- Private Function Get_Desktop() As String '¨ç¼Æ : ¶Ç¦^©Ò¦b¹q¸£ªº®à±¸ô®|
- Dim ob As Object
- Set ob = CreateObject("Wscript.Shell")
- Get_Desktop = ob.SpecialFolders("Desktop") & "\"
- End Function
½Æ»s¥N½X |
|