|
thisworkbook里放
Private Sub Workbook_Open()
Sheets("Material Request").Range("Q8") = Format(Date, "YYYYMMDD") & "-" & Format(Split(Range("Q8"), "-")(1), "000")
End Sub
任意模块里放
Sub TEST()
ActiveSheet.PrintOut
Range("Q8") = Format(Date, "YYYYMMDD") & "-" & Format(Split(Range("Q8"), "-")(1) + 1, "000")
End Sub
|
评分
-
查看全部评分
|