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

½Ð°Ýexcel¦³¿ìªk¤@¶}±Ò¦Û°Ê°õ¦æ¥¨¶°¶Ü?

½Ð°Ýexcel¦³¿ìªk¤@¶}±Ò¦Û°Ê°õ¦æ¥¨¶°¶Ü?

¦]¬°¤p§Ì¦³­Ó»Ý¨D
§Æ±æexcel¥´¶}®É¯à¦Û°Ê³sµ²¸ê®Æ®w§ó·s¸ê®Æ ,
§Æ±æ¯à§ä¨ì¤@¨Ç¸Ñ¨M¿ìªk,¨Ó´î¤Ö¤@¨Ç¨BÆJ...
³Â·Ð¤F~

§Æ±æexcel¥´¶}®É¯à¦Û°Ê³sµ²¸ê®Æ®w§ó·s¸ê®Æ ,

§â­n°õ¦æªº»yªk,©ñ¦b ThisWorkbook ©³¤U ,¨Ò¦p~
Private Sub Workbook_Open()  '¶}±ÒÀÉ®×°õ¦æ¨Æ¥ó
xxxx  --> ­n°õ¦æªº»yªk
End Sub

TOP

¤]¥i¥Hª½±µ¦b ¼Ò²Õ¤¤¨Ï¥Î auto_open ªº¤è¦¡¡A¦p¤U¡G
Sub auto_open()
     ==> ¿é¤J­n°õ¦æªº¥¨¶°
End Sub

TOP

ÁÂÁ§A­Ì §A­Ì³£¤èªk³£¦n´Î

TOP

À³¸ÓÁÙ¦³¨ä¥L¤èªk§a!Ä´¦p°k¶}¦w¥þÀˬdª½±µ¶i¤Jªº¤è¦¡,ÁöµM¬Ý¹L³oºØµ{¦¡,¥i¬O«o¤£¬O¥Î¤W­z¤èªk¹F¦¨,¥´¶}¼Ò²Õ¤]¥¼¨£¥Îvba¯S§O¼gªk.¤Ï¦Ó¦b¥\¯à°Ïª½±µ¶]¥X¿ï³æ.³oºØ§ÞªkÅý§Ú·Q¯}ÀY³£·Q¤£¥X¨Ó,¬O§_¦³°ª¤H¯à¯S§O«üÂI,ÁÂÁÂ!
´¿ªøÀM

TOP

¦^´_ 3# jsleee


    ÁÂÁ¡C¤S¾Ç¤F¤@©Û

TOP

¤p§Ì¤]¾Ç·|¤F¤@©Û

­ì¨Ó¥i¥H¥Îauto_open ³o­Ó»yªk

·PÁ¤À¨É

TOP

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2016-5-27 10:26 ½s¿è

¦^´_ 5# ceci35008
1. Àɮ׶}±Ò®É°õ¦æ´N¬O¥ÎWorkbook_Open©Îauto_open
2. Excel¬O¦³­Ó startup ¸ô®|¡A§A¥i¥H¥ÎApplication.StartupPath¬d¨ì§Aªº¸ô®|¡C
    ¥¦¬OÅý Excel À³¥Îµ{¦¡±Ò°Ê®É¡A¥´¶}³o¸ô®|¤UÀɮסC
¡@¦ý¤@¯ë±¡ªp¤£·|«Øij¥Î³oºØ¤è¦¡¡A
¡@¦]¬°1ªº±¡ªp¬O¨Ï¥ÎªÌ¦Û¤v¿ï¾Ü­n¥´¶}§t¥¨¶°ªºÀɮסA­n¦Û¤v©Ó¾á°õ¦æµ{¦¡­·ÀI¡C
¡@¦Ó2·f°t1¬Û·í©ó¬O¨Ï¥ÎªÌ¤£ª¾±¡ªº±¡ªp´N°õ¦æ¤Fµ{¦¡¡A³o¸ò¯f¬rªº¦æ¬°¦³¤K¦¨¹³¡C

3. "¥´¶}¼Ò²Õ¤]¥¼¨£¥Îvba¯S§O¼gªk?"¡A³o¥i¯à¬O¥¦ªºmodule ³QÁôÂäF
4. "¥\¯à°Ïª½±µ¶]¥X¿ï³æ"¡A³o§A­n°Ñ¦Ò¤@¨Ç¼W¯q¶°¼gªk¡A·|¥h¼W´î¥\¯à°Ï/¤u¨ã¦C

* ¸É¥R¤@¤U 2 ¤£¬O°k¶}¦w¥þÀˬd¡A¦Ó¬O¸Ó¸ô®|¤w³Q¥[¤JExcel¨ü«H¥ôªº¦ì¸m(¥i¨ì«H¥ô¤¤¤ß¬d¬Ý)
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD