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

[µo°Ý] VBA¸ô®|¸Ì­±­Y¦³ÅܼơA¦p¦ó§ï¦Û°Ê§ì?

[µo°Ý] VBA¸ô®|¸Ì­±­Y¦³ÅܼơA¦p¦ó§ï¦Û°Ê§ì?

¦p¤U­±VBA¡A¦³¨S¦³¿ìªkÅý§Úªº¸ô®|¸Ì­±ªº¹q¸£µn¤JªÌ¦Û°Ê§ì¡A¤£µM¨C¦¸µn¤JªÌ¤£¦P³£­n°»¿ù¥h§ï¸ô®|¦WºÙ¡A¦³¨D±M®a¤F¡AÁÂÁÂ


Private Sub Workbook_Open()
Workbooks.Open Filename:="C:\Users\¹q¸£µn¤JªÌ\Desktop\TEST\TEST.xlsm"
Application.EnableEvents = False
'Workbooks("TEST.xlsm").Close SaveChanges:=False
Application.EnableEvents = True
ThisWorkbook.Close
End Sub

¦^´_ 2# ­ã´£³¡ªL


  ÁÂÁ²a¤j¦^´_¡A§Ú¸ê®ÆÀɦ³¥t¥~©ñ¨ä¥L¸ô®|¡A®à­±ªº¬Ouserªº¨Ï¥ÎÀÉ¡A
¦ý¥Ñ©óuser³£·|§â¨Ï¥ÎÀɧì¤U¨Ó©ñ®à­±,©Ò¥H¤~·Q»¡¦³³o»Ý¨D for ¦]À³user¤£¦P¨ÓÅܰʸô®|

TOP

¦^´_ 4# jcchiang

ÁÂÁ¤j¤j¦^´_,§Ú¬O¤]¦³¬q¥i¥H§ìµn¤J±b¸¹ªºµ{¦¡(§ìµn¤JªÌ¨Ã¶ñ¦b¬YÄæ¦ì),¥i¬O§Ú¤£ª¾¹D«ç¼Ë§â¥L¸ò§Úªº¸ô®|µ²¦X¦b¤@°_...XD

TOP

¦^´_ 6# jcchiang


    ­ì¨Ó¬O¥Î + µ²¦X¡A§Ú¤@ª½¥Î&
ÁÂÁ¤j¤j¡A¤w¸Ñ¡C

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD