保存Analysis For Office的workbook到本地: 三部曲:
在components下面,把Remove data before saving点掉,这是针对整个workbook的 在每个数据源上面,选中打开刷新数据的方式为default refresh behavior 最后保存
1
Sub 第一问()在K13 返回男性员工的最低工资的姓名Dim i As Long, minSalary As Double, minName As StringminSalary = 1000000000For i = 2 To Range("f1").CurrentRegion.Rows.countIf Range("h" & i) = "男" And Range("i"…