µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» EXCEL¦C¦L®É,¬O§_¥i¦L¥X¬y¤ô¸¹?
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
EXCEL¦C¦L®É,¬O§_¥i¦L¥X¬y¤ô¸¹?
howard822
µoµu®ø®§
¥[¬°¦n¤Í
howard822
·í«eÂ÷½u
UID
8679
©«¤l
6
¥DÃD
0
ºëµØ
0
¿n¤À
14
ª÷¿ú
14
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
OFFICE 2003 & 2010
¾\ŪÅv
10
©Ê§O
¨k
¨Ó¦Û
¶V«n
¦b½u®É¶¡
3 ¤p®É
µù¥U®É¶¡
2012-3-22
³Ì«áµn¿ý
2013-1-21
¤p¾Ç¥Í
©«¤l
6
¥DÃD
0
ºëµØ
0
¿n¤À
14
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
OFFICE 2003 & 2010
¾\ŪÅv
10
©Ê§O
¨k
¨Ó¦Û
¶V«n
µù¥U®É¶¡
2012-3-22
³Ì«áµn¿ý
2013-1-21
1
#
¸õÂà¨ì
»
µoªí©ó 2012-3-23 00:18
|
Åã¥Ü¥þ³¡©«¤l
¥»©«³Ì«á¥Ñ howard822 ©ó 2012-3-23 00:22 ½s¿è
¤£¦n·N«ä¡ã§Ú¬OEXCEL·s¤â..¨S¦³µ{¦¡·§©À..
³z¹L·j´Mª¾¹D¶Q¯¸¡ã·Q½Ð±Ð«ü¾É§Ú¤@¤U¡ã
§Úªº»Ý¨D¬O¨C¤Ñ³£¦³¤TÁp³æ³øªín¥X³f¡A
£¸±i³øªí£¸ÓSHEET..£¸±i³øªí¦C¦L£¸¦¸¡ã¥i¬O¬y¤ô¸¹nÄ~Äò²Ö¿n¡ã
¨º§Ú§â¸Óµ{¦¡½X§ï¦¨«á¡G
Private Sub CommandButton1_Click()
If Left([I1], 6) <> Format(Date, "yymmdd") Then [I1] = Format(Date, "yymmdd") & "000"
x = Val(Right([I1], 3))
[I1] = Format(Date, "yymmdd") & "-" & Format(x + 1, "000")
Sheet1.PrintPreview
End Sub
¦bì©lSHEET¥i¥H¥¿±`ªí²{¡A¨S°ÝÃD¡C
-----------------------------------------------------------------
¥i¬O§Ú±NSHEET½Æ»s(Ctrl+¥ªÁä©ì¦²)¤§«á~
¥\¯àµLªk¥¿±`¨Ï¥Î¤F¡ã
½Ð°Ý§ÚÀ³¸Ón«ç»ò°µ¡H
¦X©ê¤§¤ì¡A¥Í©ó²@¤ì¡F¤E¼h¤§»O¡A°_©ó²Ö¤g¡F¤d¨½¤§¦æ¡A©l©ó¨¬¤U
TOP
howard822
µoµu®ø®§
¥[¬°¦n¤Í
howard822
·í«eÂ÷½u
UID
8679
©«¤l
6
¥DÃD
0
ºëµØ
0
¿n¤À
14
ª÷¿ú
14
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
OFFICE 2003 & 2010
¾\ŪÅv
10
©Ê§O
¨k
¨Ó¦Û
¶V«n
¦b½u®É¶¡
3 ¤p®É
µù¥U®É¶¡
2012-3-22
³Ì«áµn¿ý
2013-1-21
¤p¾Ç¥Í
©«¤l
6
¥DÃD
0
ºëµØ
0
¿n¤À
14
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
OFFICE 2003 & 2010
¾\ŪÅv
10
©Ê§O
¨k
¨Ó¦Û
¶V«n
µù¥U®É¶¡
2012-3-22
³Ì«áµn¿ý
2013-1-21
2
#
µoªí©ó 2012-3-27 00:25
|
Åã¥Ü¥þ³¡©«¤l
½Ð°Ýª©¥D¥i¥H«ü¾É¤p²Ä¤@¤U¶Ü¡H
¦X©ê¤§¤ì¡A¥Í©ó²@¤ì¡F¤E¼h¤§»O¡A°_©ó²Ö¤g¡F¤d¨½¤§¦æ¡A©l©ó¨¬¤U
TOP
ÀR«ä¦Û¦b :
¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦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¯»µ·