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

[µo°Ý] ¥t¦s®Éª½±µÂл\ÂÂÀÉ

[µo°Ý] ¥t¦s®Éª½±µÂл\ÂÂÀÉ

³Ìªñ±µ¤âªº³øªí¤ñ¸û¦h
¦Ó¥BÀx¦sªº¦ì¸m¤S³£¤£¤@¼Ë
©Ò¥H§Ú¦bÀɮ׸̭±¼g¤F¤@¬q¦Û°ÊÀx¦s¸ò¦Û°Ê¥t¦s
¥i¬O¥t¦sÁ`¬O·|¶]¥X¬O§_­nÂл\ÂÂÀÉ
½Ð°Ý¦U¦ì¤j¤j­n¦p¦ó­×§ïÅýExcel¥t¦sªº®É­Ô¦Û°ÊÂл\ÂÂÀÉ
¤£¦A¶]¥X´£¥Ü

  ActiveWorkbook.Save
   
    ChDir "K:\B.¦U²Õ¸ê®Æ (Team inform)\C.¥]¸Ë²Õ (Packing group)\A.­Ó¤H¸ê®Æ§¨ (Personal folder)\Joe.Wu\¤ä´©¥ÍºÞ\«æ¥ó"
    ActiveWorkbook.SaveAs filename:= _
        "K:\B.¦U²Õ¸ê®Æ (Team inform)\C.¥]¸Ë²Õ (Packing group)\A.­Ó¤H¸ê®Æ§¨ (Personal folder)\Joe.Wu\¤ä´©¥ÍºÞ\«æ¥ó\«æ¥óºÞ²z_v1_6.xlsm", FileFormat:= _
        xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False


¦^´_ 1# cowww


     Application.DisplayAlerts = False

'¦sÀÉ

    Application.DisplayAlerts = True

TOP

¦^´_ 2# quickfixer

¦¨¥\¤F
«D±`·PÁÂquickfixer¤j¤jªº«ü¾É

TOP

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD