198188

¦^´_ 43# GBKEE
1.rar (380.46 KB)

¤U¸ü¦¸¼Æ: 4

2013-1-13 00:45

2.rar (464.33 KB)

¤U¸ü¦¸¼Æ: 3

2013-1-13 00:45

3.rar (419.49 KB)

¤U¸ü¦¸¼Æ: 4

2013-1-13 00:45

vba.rar (2.65 KB)

¤U¸ü¦¸¼Æ: 3

2013-1-13 00:45

¥Ñ©óÀɮפӤj¡A§Ú¤À¶}¤F7­Ó excel ©M¤@­Óµ{¦¡ªºªþ¥ó

GBKEE

¦^´_ 42# 198188
¤W¶ÇÀɮפε{¦¡½X¬Ý¬Ý.

198188

¦^´_ 41# GBKEE


    §Ú¸Õ¹L±N¥þ³¡ªº¤é´Á®æ¦¡³£§ï¦¨¤@¼Ë¡A¦Ó¦UºØ¤é´Á®æ¦¡³£¸Õ¹L¡C
¦ý¤@°õ¦ævba´N·|¦Û°Ê±N®æ¦¡§ï¦¨¼Æ¦r¦p¤U¡A¦Ó§Ú·Q±N³o­ÓETA¤é´Á´î¨â¤é¡A¦pªG¬O¬P´Á¤»©Î¤é¡A´N¦b¥t¤@columnÅã¥ÜETA Columnªº¤é´Á¡A§_«h´NÅã¥ÜETA¤é´Á´î¨â¤é,¥Ñ©óvba¥¼¯à¿ë»{¼Æ¦r¦¨¤é´Á¡A©Ò¥H¥þ³¡³£´î2
ETA
41289.5
41291
41288.5
41295
41297
41298

GBKEE

¦^´_ 39# 198188
    ¤G­Ódata base¡A´NÅܦ¨ªþ¥ó¹Ï¤ù
FÄæ­n³]©w¬°¤é´Á®æ¦¡ ¦p¹Ï

¤U¸ü (57.98 KB)

2013-1-11 16:06

198188

¦^´_ 19# kimbal

½Ð°Ý¥i§_À°§Ú¬Ý¤@¤U¤U­±ªºlink­þ¸Ì¥X²{°ÝÃD
    http://forum.twbts.com/viewthrea ... amp;page=4#pid49510

198188

¦^´_  GBKEE

¤U¸ü (178.77 KB)

2013-1-11 10:44

§Ú³o­Óµ{¦¡À³¸ÓµL°ÝÃD¡A¦ý¬OWorksheets("Request").Range("F" & i).Value ¸g±`¥X²{¬O ...
198188 µoªí©ó 2013-1-11 10:19

§Ú²Ä¤@­Ódata base ­ì¥»¬O04-Jan-13
µM«á§ÚÂà1/4¦b²Ä¤G­Ódata base
¤§«áŪ¨ú²Ä¤G­Ódata base¡A´NÅܦ¨ªþ¥ó¹Ï¤ù¡A¼Æ­È¡A¦Ó³o­Óµ{¦¡«o¤£À´±o¿ë»{¦¨¤é´Á

198188

1.     The_day = Worksheets("Request").Range("F" & i).Value - 2
   
2.   If The_day = "¬P´Á¤»" Or The_day = "¬P´Á¤é" Then .Range("H" & i).Value = .Range("F" & i).Value Else .Range("H" & i).Value = .Range("F" & i).Value - 2

½Æ»s¥N½X

¦^´_ 37# GBKEE




§Ú³o­Óµ{¦¡À³¸ÓµL°ÝÃD¡A¦ý¬OWorksheets("Request").Range("F" & i).Value ¸g±`¥X²{¬O¼Æ­È¡A¤£¬O¤é´Á¡A¦pªGÅý¹q¸£¦Û°Ê¿ë»{³o­ÓÀx¦s®æ¬O¤é´Á¡C§ÚÀx¦s®æªº¤é´Á®æ¦¡¬O11/1

GBKEE

¦^´_ 34# 198188
³oª¬ªp§Ú¤]¤£ª¾¹D!

¦^´_ 35# 198188

1. Sub Ex()
   
2. Dim The_day As Variant
   
3. The_day = #1/1/2013#
   
4. MsgBox Format(The_day, "aaa")
   
5. The_day = Date '¨t²Î¤é´Á: ¤µ¤é
   
6. MsgBox Format(The_day, "aaa")
   
7. End Sub

½Æ»s¥N½X

stillfish00

¦^´_ 35# 198188

if WeekdayName(Weekday("2013/1/10")) = "¬P´Á¤@"
©Î
if Weekday("2013/1/10") = vbMonday

198188

¦^´_ 29# Hsieh


    ½Ð°Ý­ncheck¤@­ÓÀx¦s®æ¤ºªº¤é´Á¬O¬P´Á´X¡A¥i¥H¥Îvba¶Ü¡H