µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» Åý«ö¶sºû«ù©T©w¦ì¸m+Àx¦s®æ®æ¦¡³]©w
 
1
2
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
Åý«ö¶sºû«ù©T©w¦ì¸m+Àx¦s®æ®æ¦¡³]©w
GBKEE
µoµu®ø®§
¥[¬°¦n¤Í
GBKEE
·í«eÂ÷½u
UID
16
©«¤l
5923
¥DÃD
13
ºëµØ
1
¿n¤À
5986
ª÷¿ú
5986
ÂI¦W
0
§@·~¨t²Î
win10
³nÅ骩¥»
Office 2010
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥xÆW°ò¶©
¦b½u®É¶¡
4811 ¤p®É
µù¥U®É¶¡
2010-5-1
³Ì«áµn¿ý
2022-1-23
¶W¯Åª©¥D
©«¤l
5923
¥DÃD
13
ºëµØ
1
¿n¤À
5986
ÂI¦W
0
§@·~¨t²Î
win10
³nÅ骩¥»
Office 2010
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥xÆW°ò¶©
µù¥U®É¶¡
2010-5-1
³Ì«áµn¿ý
2022-1-23
11
#
¸õÂà¨ì
»
µoªí©ó 2012-10-31 18:10
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
10#
emma
'If E.TopLeftCell.Offset(, 5).Value > 10 Then '¤£¦n·N«ä¡A¤p©ó¥X³f¤é´Á¤Q¤é§Ú¤£ª¾¹D¸Ó«ç»ò³]
If E.TopLeftCell.Offset(, 5).Value - 10 < Date Then ' ³o¼Ë¹ï¶Ü?
½Æ»s¥N½X
TOP
emma
µoµu®ø®§
¥[¬°¦n¤Í
emma
·í«eÂ÷½u
UID
1100
©«¤l
110
¥DÃD
14
ºëµØ
0
¿n¤À
239
ª÷¿ú
239
ÂI¦W
0
§@·~¨t²Î
win xp
³nÅ骩¥»
office 2003
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
186 ¤p®É
µù¥U®É¶¡
2010-8-2
³Ì«áµn¿ý
2017-5-10
¤¤¾Ç¥Í
©«¤l
110
¥DÃD
14
ºëµØ
0
¿n¤À
239
ÂI¦W
0
§@·~¨t²Î
win xp
³nÅ骩¥»
office 2003
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2010-8-2
³Ì«áµn¿ý
2017-5-10
12
#
µoªí©ó 2012-10-31 18:58
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
11#
GBKEE
ÁÂÁÂGBKEEª©¤j¡A³o¼Ë¨S¿ù¡A¥un§â10 < Date §ï¬° 10 > Date´N¬O§Únªº¤F¡A
¡÷¦ý¬O¹³10¤ë¥÷¦³31¤Ñ¡A¨Ò¦p¥X³f¤é¦pªG¬°101/11/05¡A¶W¹L101/10/25´N¬°¡iµLªk¹wÁÊ¡j¡A
¡÷¤£¬O101/10/26¤~¡iµLªk¹wÁÊ¡j
¡÷³oÓ¦³¿ìªk¥i¥H¸Ñ¨M¶Ü?ÁÂÁÂ^^
¤U¸ü
(68.2 KB)
2012-10-31 18:57
VBAtest5.rar
(14.06 KB)
¤U¸ü¦¸¼Æ: 3
2012-10-31 18:57
TOP
Hsieh
µoµu®ø®§
¥[¬°¦n¤Í
Hsieh
·í«eÂ÷½u
UID
3
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ª÷¿ú
4916
ÂI¦W
197
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
¦b½u®É¶¡
4086 ¤p®É
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-9-7
¶W¯Åª©¥D
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ÂI¦W
197
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-9-7
13
#
µoªí©ó 2012-10-31 21:54
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
12#
emma
10¤ë¦³31¤é©Ò¥H11/5©¹«e±À10¤é±o¨ì10/26nÅܦ¨10/25
¨º»ò2¤ë¦³28©Î29¤én±o¨ì¬Æ»ò¤é´Á©O?
³W«hn¯à°÷Âç²M¤~¯à¥Î¦¨¬O¶]¥X¨Ó
¾Ç®üµL²P_¤£®¢¤U°Ý
TOP
emma
µoµu®ø®§
¥[¬°¦n¤Í
emma
·í«eÂ÷½u
UID
1100
©«¤l
110
¥DÃD
14
ºëµØ
0
¿n¤À
239
ª÷¿ú
239
ÂI¦W
0
§@·~¨t²Î
win xp
³nÅ骩¥»
office 2003
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
186 ¤p®É
µù¥U®É¶¡
2010-8-2
³Ì«áµn¿ý
2017-5-10
¤¤¾Ç¥Í
©«¤l
110
¥DÃD
14
ºëµØ
0
¿n¤À
239
ÂI¦W
0
§@·~¨t²Î
win xp
³nÅ骩¥»
office 2003
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2010-8-2
³Ì«áµn¿ý
2017-5-10
14
#
µoªí©ó 2012-11-1 12:16
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ emma ©ó 2012-11-1 12:19 ½s¿è
¦^´_
13#
Hsieh
Hsiehª©¥D¡A±z¦n¡A¬Oªº¡AÁÂÁ±z´£¿ô§Ú¡A¦pªG¬O2¤ëªº¸Ü·|¼vÅT¨ìªº¬O3¤ë¥÷¡A¥X³f¤é¦pªG¬O102/03/02ªº¸Ü¡A
¨º»òµLªk¹wÁʪº¤é´Á¬O102/02/02¡A³o¬O¬°¤F«K§Qªù¥«¤Hû¤H¤u°O¾Ðªº±Àºâªk...
¹³101/10/31¸ò101/11/01ªºµLªk¹wÁʤé¬Ò¬°
101/10/21
¥t¥~«e±¦³°Ý¹Lªº¦b¡i¬d¸ß¡jªº¤u§@ªí¤¤¡A¥i¥HÅý¤À©±ªº²M³æ¤@ÅÜ°Ê´NÅý¤U¤èªº¡iÀx¦ì¡jÄæ¦ì¸òµÛ¤@¨Ö§ó·s¶Ü?
ÁÙ¦³«ö½T©wªº«ö¶s«á¥i¥Hª½±µ¸õ¨ì¬d¸ß¤u§@ªíªº¤u§@µøµ¡À˵ø¬d¸ßªºµ²ªG¶Ü?
µM«á¥i¥H¦b¬d¸ßªº¤u§@ªí¦A»s§@«·s¬d¸ß¦^¨ì¸ê®Æªº¤u§@ªí¤¤¶Ü?
ÁÂÁÂ^^
TOP
ÀR«ä¦Û¦b :
¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
 
1
2
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·