Excel
hucailai
这个作者很懒,什么都没留下…
展开
-
合并Excel
Sub 合并当前目录下所有工作簿的全部工作表() Dim MyPath, MyName, AWbName Dim Wb As Workbook, WbN As String Dim G As Long Dim Num As Long Dim BOX As String Application.ScreenUpdating = False My...原创 2020-02-08 10:36:23 · 172 阅读 · 0 评论 -
拆分excel为多个文件
目标如下图所示:可以按班级拆分为a1,a2,a3,a100,生成四个execl文件,分别以这4个班级名为文件名。 进入VBA界面,新建模块,赋值下面的代码 Sub Macro1() Dim myRange As Variant Dim myArray Dim titleRange As Range Dim title As String Dim...原创 2020-02-08 09:49:21 · 1180 阅读 · 1 评论