|
本帖最后由 百度不到去谷歌 于 2014-4-15 21:07 编辑
结合sql比较方便- Function SqlToArr(sql$) '查询结果到数组,通用函数 其他地方调用也极其方便,建议收藏
- Dim cnn As Object 'New ADODB.Connection
- Dim rs As Object, arr 'New ADODB.Recordset
- Set cnn = CreateObject("adodb.connection")
- cnn.Open "Provider = Microsoft.Jet.Oledb.4.0;Extended Properties ='Excel 8.0';Data Source =" & ThisWorkbook.FullName
- On Error Resume Next
- Set rs = cnn.Execute(sql)
- SqlToArr = rs.GetRows '注意行列与excle是反的
- End Function
- Public Sub 批量创建文件夹()
- Dim sql$, arr, p$, i&, j&, k&, s$
- s = "SELECT distinct key1 from [Sheet1$] where not key2 is null"
- For i = 1 To 3 '3列可更改
- p = Sheet1.Cells(1, i)
- sql = Replace(s, "key2", p) '构造当前级不为空条件
- For k = i - 1 To 1 Step -1 '构建完整目录字符串
- p = Sheet1.Cells(1, k) & " & '\' & " & p
- Next
- sql = Replace(sql, "key1", p) '构造当前级全路径
- Debug.Print sql
- arr = SqlToArr(sql)
- For j = 0 To UBound(arr, 2)
- MkDir ThisWorkbook.Path & "" & arr(0, j) '建立文件夹
- Next
- Next
- End Sub
复制代码
D批量建立多级文件夹批量1.rar
(15.24 KB, 下载次数: 126)
|
评分
-
1
查看全部评分
-
|