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

[µo°Ý] (¤v¸Ñ¨M)½Ð¨D¤j¤j­ÌÀ°§Ú¼g¥H¤U¥N½X!(¦]Formatªº­­¨î,¨Ï§Ú§¹¦¨¤£¤F¤U¥b¬q)!

[µo°Ý] (¤v¸Ñ¨M)½Ð¨D¤j¤j­ÌÀ°§Ú¼g¥H¤U¥N½X!(¦]Formatªº­­¨î,¨Ï§Ú§¹¦¨¤£¤F¤U¥b¬q)!

¥»©«³Ì«á¥Ñ StanleyVic ©ó 2011-8-5 14:45 ½s¿è

¬G¨Æ¬O³o¼Ëªº:
¥»¤H¦³¤@­ÓFile, ¦¹¤å¥óùئ³¤u§@ªí¦³4±i,¤À§O:Daily,Sheet2,Data, (¦]¬°¬Y¨Ç­ì¦]3±i¤u§@ªíªºFormat¬O©T©wªº) ¤Î Test (format ¥i¥H¥ô·NÅÜ°Ê-->¥D¬O¬°¤F¼g VBA ¦Ó¥Í¦¨ªº)
­n¨D³q¹LDaily¤ºùتº¸ê®Æ¦A°Ñ·Ódataªº­n¨D,¤Æ¦¨«ü©w¼Æ¾Ú¥hTest¤¤ , ¦A§â³o­Ótestªº¼Æ¾Ú¸ò¾ÚSheet2ªº«ü©wformat­n¨D·h¶i¥h!

¥Ø«e±¡ªp: ¤p§Ì¤v¸g¥ÎVBA§â¤W­z³o²Ä¤@part§¹¦¨,¤v¸g¦¨¥\¤Æ¦¨¤F«ü©w¼Æ¾Úªº¸ê®Æ¨ì"Test"ªº¤u§@ªí¤¤.

½Ð¨DÀ°§U: ¦ý¦]¬°sheet2¤¤¦³¤@©wªº­n¨D,¯S§O´N¬O¨C¤@¤é­n¥H¥|¦æ¬°¬Û¶Z,³o¤@ÂI¥d¦í¤F§Úªº«ä¦Ò,§Ú¤£·|¦p¦ó¼g,¤~¯à§âªíTestªº¸ê®ÆMove-In¨ìsheets¤¤.

ps: ¦A¦¸·Ð½Ð¤j¤j­ÌªºÀ°§U! ,½Ð¬ÝPart One ªººt¥Ü,¬°¤F¤è«K±o¨ì¤j¤jªºÀ°§U¥»¤Hªþ¥ó¤¤¥u¦³¤u§@ªíTest ©MSheet2.(ÁÂÁÂ)
Book1.zip (6.98 KB)

0001.gif
NeverTry , NeverNo !

¥»©«³Ì«á¥Ñ StanleyVic ©ó 2011-8-5 12:55 ½s¿è

¦^´_ 7# Hsieh

    ¦^¤j¤j, ¦n¹³¤FÁÙ¦³ ¬P´Á¤Ñªº ¨º¤@¬q.. («¢«¢.. §Ú¦Û¤v¼g¦^¥h§a.ÁÂÁÂ..)
§Ú¤v§â©Ò¦³³o­Ó TintAndShade = 0 §R°£¤F..  
§Aªº¥N½X¤v¸gok~ ¥i¥H¹ê²{¤F.. ( ÁÂÁ§Aªº«ü¾É.)
©Z¥Õ.¤ñ§Ú¼gªº¤èªk. §Aª½±µ¦n¦h.§Ö¦n§Ö..§ÚÁÙ¶}·sªí.ºCºC¾É¤J...
NeverTry , NeverNo !

TOP

¦^´_ 6# StanleyVic


    ª©¥»°ÝÃD¡A®æ¦¡¥X¿ù³¡¤À³£§R¤F¡A©Ç§Ú°½Ãi¥Î¿ý»sªº
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ StanleyVic ©ó 2011-8-5 12:28 ½s¿è

¦^´_ 5# Hsieh

¤j¤j~~~>_<"!!~·Q¤£¨ì,§Ú¥Î¤F®t¤£¦h2¤Ñ®É¶¡.·Q¨Ó·Q¥h..ÁÙ¤£¨ì§A2­Ó¤p®É´N§â§ÚªF¦èk-o..
¥´À»¦n¤j.!!! haha~~ÁÙ¬O­n¦h¦h¾Ç²ß¾Ç²ß¦A¾Ç²ß!!!!
(§A¼gªºªF¦è,§ÚÁÙ¬OºCºC®ø¥N¤@¤U..«ç¤]¦n..ÁÂÁ§A«ü¾É!!)
  
e~~~ ¬O¤£¬O...§Ú·d¿ù¤F¤°»ò,.¦n¹³¥X¿ù¤FÂI¤°»ò...
   
NeverTry , NeverNo !

TOP

¦^´_ 4# StanleyVic
©Ò¥H¬O­n¼g¨ìSheet2Åo!
°ÝÃDsample(§ó·s).zip (269.67 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

³o­Ó´N¬O³Ì­ìª© ¦P¨Æ­Ì ­n¨Dªº¸ê®Æ!
½Ð¤j¤j­Ì¬d¾\ !
°ÝÃDsample(§ó·s).zip (265.56 KB)

§Úı±o¦Û¤v ( ¨è·N¶}¦h¤@±i¤u§@ªí"test" ¦n¹³¶]¤F¦n¦h»·¸ô...)
NeverTry , NeverNo !

TOP

¦^´_ 2# StanleyVic


    µ{¦¡¶]§¹§Aªºµ²ªG¦b­þ¸Ì?¬Ý¤£À´§Aªº»Ý¨D
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ StanleyVic ©ó 2011-8-4 20:44 ½s¿è

¸U¤dµh­W«á¡D¡D¡D¥þ­Ó¤å¥ó²×©ó¡D§¹¦¨¤F

¡G VBA - Sample(§ó·sª©¥»).zip (272.11 KB)

¦ý¦]¤p§Ì¤£¤~¡A¤¤¶¡¨«¥ª¦n¦hÅs¸ô¡D¥ý¨ì逹§Ú­nªºªF¦è¡D
½Ð¦U¦ì½ç±Ð¡I¦³«ÝÀu¤Æ¡D¡D¡D¡D
NeverTry , NeverNo !

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD