- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 246
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-12
|
¦^´_ 25# ©P¤j°¶ - Sub Ex()
- Dim y$, Ar(), w$, j%, i%
- y = InputBox("¿é¤J¦~¤À", , Year(Date))
- If y = "" Then Exit Sub
- For i = 1 To 12
- d = Day(DateAdd("m", 1, DateSerial(CInt(y), i, 1)) - 1)
- ReDim Preserve Ar(1 To 2, 1 To d)
- For j = 1 To d
- w = Replace(Format(Weekday(DateSerial(CInt(y), i, j), 2), "aaa"), "¶g", "")
- Ar(1, j) = j
- Ar(2, j) = w
- Next
- Sheets(i & "¤ë").[G2:AK3] = ""
- Sheets(i & "¤ë").[G2].Resize(2, d) = Ar
- Erase Ar
- Next
- End Sub
½Æ»s¥N½X |
|