- ©«¤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
|
¦^´_ 1# wufonna
ChrW(160)¬O¤£¥i¨£¦r¤¸,³y¦¨¿ù»~ªº¥Dnì¦]- Option Explicit
- Sub MkDirs()
- Dim i As Integer, N As String, strPath As String
- MsgBox ¤u§@ªí1.Range("B136")
- '? ¬°ChrW(160)¬O¤£¥i¨£¦r¤¸,³y¦¨¿ù»~ªº¥Dnì¦]
- ¤u§@ªí1.Cells.Replace ChrW(160), "", xlPart '²M°£¤u§@ªí¤¤ChrW(160)¤£¥i¨£¦r¤¸
- MsgBox ¤u§@ªí1.Range("B136")
- For i = 2 To 1409
- strPath = ThisWorkbook.Path & "\" & " (" & ¤u§@ªí1.Range("A" & i).Value & ")" & ¤u§@ªí1.Range("B" & i)
- 'kimbal ª©¥D «Øij¬d¬ÝµL«ÂЫإߥؿý
- If Len(Dir(strPath, vbDirectory)) = 0 Then MkDir strPath
- Next
- End Sub
½Æ»s¥N½X |
|