各位大神,请问2016版激活工作簿的代码为什么在有些电脑运行没有问题,有些电脑又出问题(标颜色的代码出错)
Sub 打开数据源()
Dim fname As String
Dim fnames As String
Dim wb As Workbook
Dim wb1 As Workbook
Dim maxLineS As String
Dim maxLine As String
'old数据表计算
For x = 2 To maxLineS
ActiveWorkbook.Sheets("old数据").Range("n2:n" & maxLineS) = Date - 1
With ActiveWorkbook.Sheets("old数据")
n = InStr(.Range("b" & x), ".")
If n > 0 Then .Range("o" & x) = Left(.Range("b" & x), n - 1) Else .Range("o" & x) = "没有名字"
End With