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

[µo°Ý] [µo°Ý] ½Ð°ÝEXCEL¯à§_¦Û°Ê¶ñ¤J¨Ï¥ÎªÌ¦WºÙ

[µo°Ý] [µo°Ý] ½Ð°ÝEXCEL¯à§_¦Û°Ê¶ñ¤J¨Ï¥ÎªÌ¦WºÙ

¦b¦@¥ÎÀɮק¨¤º¦³¾ú¦~²Ö¿n¤U¨Óªº¤W¤d­ÓEXCELÀɮסA«ö·Ó¦UºØ¥i¯àª¬ªp¼g¦n¤£¦Pªºµ{¦¡©M¤ÀÃþ

¨Ï¥ÎªÌ³s¤J¸ê®Æ§¨¤¤¡A¦b¤u§@¤ÀÃþ¤¤§ä¨ì¹ïÀ³ªºEXCELÀÉ®×
¥u»Ý­n¡G¥´¶}ÀɮסB¶ñ¤J¼Æ­È¡B§ó§ï¶ñªí¤H©m¦W¡B¦C¦L¯È¥»
¤£»Ý­n¦sÀÉ

½Ð°Ý¡u¶ñªí¤H©m¦W¡v³o­ÓÀx¦s®æ¡A¦³¨S¦³¤½¦¡¥i¥H¦Û°Ê¶ñ¤J©m¦W¡H
³Ì¦n¬O¯à§ì¨úEXCEL³nÅé³]©wªº¨Ï¥ÎªÌ¦WºÙ¡A¨ä¦¸¬O§ì¹q¸£¨Ï¥ÎªÌ¦WºÙ©Î¬O¹q¸£¦WºÙ
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

·PÁ­ã¤j

§ï¥Î©w¸q¦WºÙ¤è¦¡¥i¥H¨Ï   ¦b³o¸Ì¤U«ü¥O¤Ó¯«©_¤F
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-2-19 10:52 ½s¿è

§ï¥Î"©w¸q¦WºÙ", §R±¼vba¦Û­q¨ç¼Æ
©w¸q¦WºÙ:=MyName
©w¸q¤½¦¡:=GET.DOCUMENT(36)&T(NOW())

Àx¦s®æ¤½¦¡:=MyName

TOP

¤w¸g«Ø¥ßªºÂÂÀɮסA¥Ø«e¹B§@³£¥¿±`¡A¨C¦¸¶}±ÒÀɮ׮ɭԩm¦W³£¥i¥H¦Û°Ê¨ê·s

¸É¥Rµo°Ý
§Ú»Ý­n¦bÂÂÀɮפ¤½Æ»s¬Y¨Ç¤u§@ªí¥X¨Ó¡A²Õ¦X¦¨·sªº¼ËªOµ¹¦P¤¯¨Ï¥Î¡A
°µªk¬O¥´¶}ÀɮסA§ä¨ì»Ý­nªº¤u§@ªí¡A¦b¤u§@ªí¼ÐÅÒ¤WÂI¥kÁä-½Æ»s-«Ø¥ß°Æ¥»-¿ï¾Ü[·s¬¡­¶Ã¯]

¦]¬°³o¤T¦æ«ü¥O¬O©ñ¦bÂÂÀɮתº¼Ò²Õ¤¤
Function MyName()
MyName = Application.UserName
End Function
©Ò¥HÅܦ¨±q¤u§@ªíª½±µ«Ø¥ß°Æ¥»¥X¨Ó²£¥Íªº·s¬¡­¶Ã¯¡A·|¯Ê¤Ö³o­Ó¦Û­q¼Ò²Õ¡A»Ý­n¤â°Ê­«·s´¡¤J¼Ò²Õ

½Ð°Ý¦³¨S¦³¿ìªkÅýEXCEL¦b«Ø¥ß·s¬¡­¶Ã¯ªº®É­Ô¡A¯à®M¥Î½d¥»¤§Ãþªº¡AÅý©Ò¦³·sªº¬¡­¶Ã¯³£¦Û°Ê²£¥Í³o¤T¦æªº¦Û­q¼Ò²Õ¡H

§Ú¸Õ¹L§â¦Û­q¼Ò²Õ¥[¦bPERSONAL.XLSB¡AÅýEXCEL±Ò°Ê¦Û°Ê¸ü¤J¡A¦ý¬OµLªk¹B§@
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

TOP

§ä¤£¨ì¤£·|¦Û°Ê§ó·sªº°ÝÃD¦b­þ?
¸Õ¸Õ­×§ï¤½¦¡¬Ý¬Ý:
=MyName()&T(NOW())

­YÁÙ¤£¦æ, ¥Îworkbookopen§a! ...
­ã´£³¡ªL µoªí©ó 2019-2-13 14:19


·PÁÂ ¦^ÂÐ

§ï¥Î¤½¦¡ =MyName()&T(NOW())  ¥Ø«e¥i¥H¥¿±`§ó·s

¥t¥~§ä¨ì¤@­Ó¤èªk¡A¬O¦b workbookopen ¥[¤J application.calculatefull¡A¦P®É´ú¸Õ¤¤
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

TOP

¦^´_  luckeyfly

¤£·|¦Û°Ê§ó·sªÌ¥i¯à¬O¦bEXCELªº¦Û°Ê­«ºâ³]©w¨ú®ø
Hsieh µoªí©ó 2019-2-13 09:21


¦^ÂÐ

¦Û°Ê­«ºâªº³]©w¥¿½T¥´¤Ä
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

TOP

§ä¤£¨ì¤£·|¦Û°Ê§ó·sªº°ÝÃD¦b­þ?
¸Õ¸Õ­×§ï¤½¦¡¬Ý¬Ý:
=MyName()&T(NOW())

­YÁÙ¤£¦æ, ¥Îworkbookopen§a!!

TOP

¦^´_ 7# luckeyfly

¤£·|¦Û°Ê§ó·sªÌ¥i¯à¬O¦bEXCELªº¦Û°Ê­«ºâ³]©w¨ú®ø

   
¥¼©R¦W.png
2019-2-13 09:20
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¸É¥R ´ú¸Õµ²ªG

¤£·|¦Û°Ê§ó·sªºÀɮסA¥Î§Ö³tÁä CTRL+ALT+SHIFT+F9 ¥i¥H¨ê·s¬°¥¿½Tªº¨Ï¥ÎªÌ©m¦W¡Aªí¥Ü¨ç¼Æ¬O¥¿½Tªº¡A¥u¬O¤£ª¾¹D¬°¬Æ»ò¦bÀɮ׶}±Ò®É¤£·|¦Û°Ê§ó·s
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

TOP

¦^´_ 4# Hsieh

H¤j

§Ú¦]¬°»Ý­nÀx¦s®æ¬OÅܰʪº(®Ú¾Ú¤£¦P¨Ï¥ÎªÌ¦Û°ÊÅܧó¦WºÙ)
©Ò¥H
1¡B¨C­Ó¨Ï¥ÎªÌ¦bEXCELªº¿ï¶µ¤¤¡A¨Ï¥ÎªÌ¦WºÙ³£¿é¤J¦Û¤v¦W¦r
2¡B©Ò¦³EXCELÀɮ׳£¦b¼Ò²Õ¥[¤J«ü¥O
Function MyName()
MyName = Application.UserName
End Function
3¡B¦b»Ý­nªºÀx¦s®æ¤¤¨Ï¥Î =MyName() «ü¥O
4¡BÀɮשñ¦b¤À¨É¸ê®Æ§¨¤¤¡Aµ¹¨Ï¥ÎªÌ³s½u¶}±Ò
²z½×¤W¡A¨C­Ó¨Ï¥ÎªÌ¶}±ÒÀɮ׫᳣·|¦Û°Ê§ó·s¦¨¦Û¤vªº¦W¦r

µo²{°ÝÃD¬O
¦³¨ÇÀÉ®×Àx¦s®æÅã¥Üªº©m¦W·|¦Û°Ê§ó·s
¦³¨ÇÀÉ®×Àx¦s®æÅã¥Üªº©m¦W·|ºû«ù¤W¤@­Ó¨Ï¥ÎªÌªº¦W¦r¡A¥²¶·¥´¶}Àx¦s®æ(¶i¤J½s¿è¤½¦¡¼Ò¦¡)¦benter¤@¦¸¡A¦W¦r¤~·|§ó·s

Àɮצbªþ¥ó¡A³Â·Ð½Ð¬Ý¤@¤U¬O­þ¸Ìªº³]©w¦³¿ù»~¡AÁÂÁÂ

¦Û°Ê§ó·s²§±`.rar (160.78 KB)
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD