Excel
Excel基础+ExcelVBA
小轩窗Candy
这个作者很懒,什么都没留下…
展开
-
Excel公式相对引用转为对应数值
计算仓储费:要把Excel里显示的公式换成引用的数值,以便转换为文本格式导入到MySQL里。VBA function:Function TFFormula(rng As Range)Dim fl As Stringfl = rng.FormulaDim reg As Object, mt As Object, res As StringSet reg = CreateObject("vbscript.regexp")With reg .Global = True .Patt.原创 2021-08-24 14:58:23 · 533 阅读 · 0 评论 -
VBA另存指定工作表并改名
Sub sheet另存为工作簿() Sheets(Array("人员档案", "明细一", "明细二", "明细三")).Copy Workbooks(Workbooks.Count).SaveAs ThisWorkbook.Path & "/" & "数据备份.xls"End Sub原创 2021-07-14 11:51:03 · 4072 阅读 · 0 评论