VBA怎么新建文件夹

代码实现重新构建所有链接,如果要单独刷新某文件夹的文件链接，可仿效代码（可不用单独刷新，如有增删，重新全部构建）。Subtest()Dimfso,fp,ar,ar1,subf,f,n%,m%,i%,j%,cAsRangeSheets("6月").ActivateActiveSheet.UsedRange.Offset(2)=""Setfso=CreateObject("scripting.filesystemobject")Setfp=fso.getfolder(ThisWorkbook.Path).subfoldersReDimar(1Tofp.Count)ForEachsubfInfpn=n+1Ifsubf.Files.Count0ThenReDimar1(1Tosubf.Files.Count)m=0ForEachfInsubf.Filesm=m+1ar1(m)=f&"|"&fso.getbasename(subf)&"|"&fso.getbasename(f)Nextar(n)=ar1EndIfNextFori=1ToUBound(ar)IfIsArray(ar(i))ThenSetc=Rows(1).Find(Split(ar(i)(1),"|")(1))IfNotcIsNothingThenForj=1ToUBound(ar(i))Withc.End(xlDown).Offset(1).Value=Split(ar(i)(j),"|")(2)ActiveSheet.Hyperlinks.AddAnchor:=.Offset(1),Address:=Split(ar(i)(j),"|")(0)EndWithNextEndIfEndIfNextSetfso=NothingEndSub