年月日を変数に入れる

yyyy = Year(Now()): mm = Month(Now()): dd = Day(Now())
If Len(mm) = 1 Then mm = "0" & mm
If Len(dd) = 1 Then dd = "0" & dd