![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Excel实用技术
chadm
这个作者很懒,什么都没留下…
展开
-
VBA比较2个Excel文件差异工具
后文的代码以及实现的完整都在如下Github文件上可以找到vba比较2个excel差异工具实现效果如下图:实现原理:Sub 按钮3_Click() Dim wb1, wb2 As Workbook Dim sheetNum, colNum, rowNum As Integer Dim sheet1, Sheet2, sheetTarget As Worksheet Dim diffName As String Dim name1, name2 As Str原创 2020-06-06 15:00:21 · 4011 阅读 · 3 评论 -
实用VBA代码
打开Excel表格Function openExcel(name As String) Dim wb As Workbook Dim sheetFrom As Worksheet '判断文件是否存在 If Dir(name) <> "" Then Debug.Print name + "文件存在&q原创 2018-08-11 00:20:28 · 7920 阅读 · 1 评论