liheao的博客

原创 vba 查找第一个单元格A1 在本表位置中查找其他excel的和A1相似的单元格，并且定位

Sub XO() Dim strPath As String strPath = ThisWorkbook.Path Call getExcelFile0(strPath) End Sub Sub getExcelFile0(sFolderPath As String) On Error Resume Next Dim f As String Dim file() As String x =...