|
- Sub Start()
- Range("G3").Value = Format(Now(), "yyyy-MM-dd hh:mm")
- x = Range("b3")
- If Format(Now, "yyyymmdd") = Left(x, 8) Then
- Range("b3") = Left(x, 8) & Format(Val(Right(x, 6)) + 1, "000000")
- Else
- Range("b3") = Format(Now, "yyyymmdd") & Format(1, "000000")
- End If
- End Sub
复制代码 |
|