自动按列分组拆分excel工作表

仅供个人参考分excel工excel以达或者vbs的excel因为大量文档ALT+F11进---【模块】F5，不得用于商业用途

仅供个人参考建码开始SubCFGZB()DimmyRangeAsVariantDimDimtitleRangeAsRangeDimtitleAsStringDimShNameStringDimcolumnNumIntegermyRange=请择标题行",Type:=8)myArray=WorksheetFunction.Transpose(myRange)SettitleRange=Application.InputBox(prompt:="请择拆分的表头，必须是第一行，且为一个单元格，如：姓",Type:=8)titletitleRange.Value=titleRange.ColumnApplication.Volatile=Application.ScreenUpdating=FalseApplication.DisplayAlerts=FalseDimi&,Myr&,Arr,num&Dimd,kFor=Sheets.Count1Step-1Sheets(i).Name<>Sheets(i).DeleteEndIfNextiSet=CreateObject("Scripting.Dictionary")Worksheets(ShName).Arr=Worksheets(ShName).Range(Cells(2,columnNum),Cells(Myr,columnNum))For=Tod(Arr(i,1))=Nextkd.keysFor=Tok(i)<>Set=CreateObject("adodb.connection")conn.Open"provider=;extendedproperties=excel8.0;datasource="&ThisWorkbook.FullNameSql"select*["&"&title&"='"&k(i)"'"Worksheets.Addafter:=Sheets(Sheets.Count)WithActiveSheet.Namek(i)For=1ToUBound(myArray)不得用于商业用途

仅供个人参考.Cells(1,num)=myArray(num,1)Next.Range("A2").CopyFromRecordsetconn.Execute(Sql)EndSheets(1).SelectSheets(1).Cells.SelectSelection.CopyWorksheets(Sheets.Count).ActivateSelection.PasteSpecialPaste:=xlPasteFormats,Operation:=xlNone,_SkipBlanks:=False,Transpose:=FalseApplication.CutCopyMode=FalseEndIfNexticonn.CloseSet=NothingApplication.DisplayAlerts=TrueApplication.ScreenUpdating=True‘分至工作表完毕，开始拆分至单独件，如无需拆分至文件，请将以下代码删除，保留最后一行EndSub结语DimshtAsWorksheetDimMyBookAsWorkbookSetMyBook=Setfso=CreateObject("scripting.filesystemobject")fso.createfolder(MyBook.Path"\"&ForshtMyBook.Sheetssht.Name<>Thensht.CopyActiveWorkbook.SaveAsFilename:=MyBook.Path&"\"&ShName"\"&sht.Name,FileFormat:=xlNormalActiveWorkbook.CloseEndIfNextMsgBox文已经被拆完!EndSub‘vbs代结束不得用于商业用途

仅供个人参考仅供个用学习、究不得用商业用。Forpersonaluseonlyinstudyandresearch;notforcommercialuse.NurfürdenpersönlichenfürStudien,Forschung,zukommerziellenZweckenverwendetwerden.Pourl'étudeetrechercheuniquementàdesfinspersonnelles;pasàdesfinscommerciales.тольк