上一页 1 ··· 3 4 5 6 7 8 9 10 11 ··· 19 下一页
摘要: Sub 计算高一优秀合格率() Dim Wb As Workbook Dim Sht As Worksheet Dim oSht As Worksheet Dim dOs As Object 'OutStanding Const SUBJECTS = "语文数学英语物理化学生物政治历史地理" Set dOs = CreateObject("Scri... 阅读全文
posted @ 2018-10-13 20:48 wangway 阅读(493) 评论(0) 推荐(0) 编辑
摘要: '年级报表拆分为班级报表 Public Sub CreateClassReport() Application.DisplayAlerts = False Dim Wb As Workbook Dim OneSht As Worksheet Dim NewWb As Workbook Dim FolderPath As String Di... 阅读全文
posted @ 2018-10-13 19:52 wangway 阅读(368) 评论(0) 推荐(0) 编辑
摘要: Public Sub 高一成绩报表() Application.ScreenUpdating = False Application.DisplayAlerts = False Application.Calculation = xlCalculationManual Application.StatusBar = ">>>>>>>>程序正在运行>>>>... 阅读全文
posted @ 2018-10-13 13:11 wangway 阅读(295) 评论(0) 推荐(0) 编辑
摘要: Sub CreateGoalPictures() '声明变量 Dim Wb As Workbook Dim Sht As Worksheet Dim Shp As Shape Dim Pic, EndRow Dim FilePath, StudentName '设置变量 Set Wb = Application.ThisWorkbo... 阅读全文
posted @ 2018-10-13 12:45 wangway 阅读(330) 评论(0) 推荐(0) 编辑
摘要: Sub TransferData() AppSettings Dim StartTime As Variant Dim UsedTime As Variant StartTime = VBA.Timer On Error GoTo ErrHandler Dim dHas As Object Dim dNew A... 阅读全文
posted @ 2018-10-11 23:30 wangway 阅读(342) 评论(0) 推荐(0) 编辑
摘要: Public Sub QuickConsolidateMethod() '声明变量 Dim Wb As Workbook, OpenWb As Workbook Dim Sht As Worksheet, OneSht As Worksheet Dim Rng As Range, OneRng As Range, RangeAddress As Strin... 阅读全文
posted @ 2018-10-06 11:10 wangway 阅读(648) 评论(0) 推荐(0) 编辑
摘要: 方案一:数据少时省事 Private Sub CustomTransform1() Dim Wb As Workbook, Sht As Worksheet Dim NewSht As Worksheet, Dic As Object Dim EndRow As Long, iRow Set Dic = CreateObject("Scrip... 阅读全文
posted @ 2018-10-06 11:05 wangway 阅读(347) 评论(0) 推荐(0) 编辑
摘要: Sub AdjustRowHeight0() Dim ModelSheet As Worksheet, PrintSheet As Worksheet Dim ModelRng As Range '模板单元格 Dim modelRowHeight() As Double '模板行高数据 Dim modelRowCount As Long '模板行数 Dim... 阅读全文
posted @ 2018-10-06 10:50 wangway 阅读(228) 评论(0) 推荐(0) 编辑
摘要: Sub WorkbooksConsolidate() Rem 设置求和区域为 sheet名称/单元格区域;sheet名称/单元格区域 Const Setting As String = "Sheet1/A1:G6;Sheet1/A8:E8;Sheet1/F8:G8;Sheet2/A1:G3;Sheet2/A5:G5" Const FOLDER_NAME As String... 阅读全文
posted @ 2018-08-31 11:03 wangway 阅读(221) 评论(0) 推荐(0) 编辑
摘要: Sub WorkSheetsConsolidate() Rem 设置求和区域为 单元格区域;单元格区域 Const Setting As String = "A1;B2:C4" Dim StartTime As Variant Dim UsedTime As Variant StartTime = VBA.Timer AppSetting... 阅读全文
posted @ 2018-08-31 11:00 wangway 阅读(255) 评论(0) 推荐(0) 编辑
上一页 1 ··· 3 4 5 6 7 8 9 10 11 ··· 19 下一页