Excel2003的最大行是65536行,从Excel2007开始最大行是1048576.
xls是2003版本下的文件,不管有没有宏程序的话都是xls文件, 2007做了区分 XLSM文件.
- Sub AAA()
- a = Range("zz1").End(xlDown).Row
- If a <= 655336 Then
- Set eb = Workopens(ThisWorkbook.Path & "\附件.xls")
- Else
- Set eb = Workopens(ThisWorkbook.Path & "\附件.xlsm")
- Else
- End If
- End Sub
复制代码