ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[¤À¨É] ½L¤¤ DDE ¦sÀÉ»P VBA ªº¹ê»ÚÀ³¥Î½d¨Ò

³ø§i:®M¦b2010 ¦³°ÝÃD
½s¿è¿ù»~¡A¸Ó¦¨­û¤w¦s¦b©ó¦¹ª«¥ó¼Ò²Õ©ÒÄ~©Óªº¼Ò²Õ¤¤
Dim index As Single
==========
¦]¬°ÁÙ¬O¤p¾Ç¥Í¡A©Ò¥H°ÝÃD¯S§O¦h

TOP

¦^´_ 5# Hsieh

ÁÂÁ ¶W¯Åª©¥D ¤ÎC_C LAI ¸Ñ»¡
index   ==> CIndex
¤w±N§ï¥¿«á°õ¦æ
¤S¦³¤G­Ó°ÝÃD   Call newTitle  &  ThisWorkBook.onStarter
¨S¦³©w¸q    newTitle
                ³o¬O­n¦bSheet2 «Ø¥ß¤@­Ó¤é´Á(A1)¡B®É¶¡(B1)¡A¦¬½L»ù(C1) ?
µLªk¶}±Ò  ThisWorkBook.onStarter

³o­Óµ{¦¡ªº¥Î·N¬O§â½L¤¤DDEªº¼Æ¦r°O¿ý¦¨¸ê®Æ¶Ü
   

ÁÂÁÂ
¯qÁ¨à

TOP

µLªk°õ¦æ¸Ó¥¨¶°

thisworkbookonstarter.JPG
2012-4-14 15:29
¦^´_ 8# c_c_lai
µLªk°õ¦æ¸Ó¥¨¶°¡A¤£ª¾°ÝÃD¥X¦b­þ¸Ì¡C
§Ú¸Õ¹L«Ü¦h¦¸¡AÁÙ¬O¤£¯à§¹¦¨³o»ò¦nªºµ{¦¡¡C
½Ð¨DÀ°¦£
¯qÁ¨à

TOP

¥»©«³Ì«á¥Ñ ajagow ©ó 2012-4-14 20:51 ½s¿è

DDE-4-14.rar (9.1 KB) ¦^´_ 10# c_c_lai
½ÐÀ°¦£¡AÁÂÁ¡C
EXCEL ¤w¸g«ÜÃø¤F¡A·Q¤£¨ìVBA§óÃø
¯qÁ¨à

TOP

¥»©«³Ì«á¥Ñ ajagow ©ó 2012-4-15 17:24 ½s¿è

¦^´_ 14# c_c_lai
·PÁ  ª©¥Dªº»¡©ú¤Îc c lai ­×§ïªºµ{¦¡
¯uªº·|¦Û¤v¶]
¤Ó¯«¤F
½¤«ô¤¤
¯qÁ¨à

TOP

¼ÒÀÀ¹Ï

¤Á5¤p®É.JPG
2012-4-24 19:28
¦^´_ 13# c_c_lai


    C  C  LAI   ¤j¤j
§Ú²{¦b¦³¤@­Ó°ÝÃD?´N¬OEXCEL ¦b¶]ªº¦³®É­Ô·|¦Û°Ê°±¡A®É¶¡ÁÙ¬OÄ~Äò¬y³u¡C¦³¨Ç¸ê®Æ¨S¦³°O¿ý¨ì
¨º¦pªG§â·Q§â®É¶¡¤Á¦¨¤­­Ó¤p®É¨Ó­Ó§O°O¿ý¤£ª¾¹D¦³¨S¦³¿ìªk
08:45:00~09:44:59
09:45:00~10:44:59
10:45:00~11:44:59
11:45:00~12:44:59
12:45:00~13:44:59
¨Ó§ì¨ú¤p®Éªº¦¨¥æ»ù
³o­Ó«ÜÃø¡A§Ú¥h¤À¨â¬q¡A¥u¬Ý¨ìEXCELªº·Æ¹«¤@ª½µe¶ê°é.¹q¸£´N·íµÛ¡C
¯qÁ¨à

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD