使用道具 举报
学习
Sub Folder()On Error Resume NextMkDir ThisWorkbook.Path & "\我"
MkDir ThisWorkbook.Path & "\爱"
。。。。。End Sub
看看雨狐的,,,哈哈
Public Sub crreate_dir()Dim fs, arr(), i
arr = Array("wo", "ai", "dianzi", "biaoge")Set fs = CreateObject("scripting.filesystemobject")
For i = 0 To UBound(arr) fs.createfolder (ThisWorkbook.Path & "\" & arr(i))Next
End Sub
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-4-29 10:53 , Processed in 0.562329 second(s), 8 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.