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

Åý¥¨¶°¥t¦s·sÀÉ,¥H«ü©wªºÀx¦s®æ©R¦W

Åý¥¨¶°¥t¦s·sÀÉ,¥H«ü©wªºÀx¦s®æ©R¦W

¦U¦ì¤j¤j¦n,
³o¬O§Ú¿ý»sªº¥¨¶°,¦b°õ¦æ§¹«á¥t¦s·sÀÉ,¦ý·Pı¤£¤Ó¦n¥Î,§Ú·Q§ï¬°Åý¥¨¶°¥t¦s·sÀÉ,¥H«ü©wªºÀx¦s®æ©R¦W,
§Ú¦p¦ó­×§ï¥H¤Uªº¥¨¶°µ{¦¡?
ChDir "P:\BCM\Shipping Doc\PJ_¥X³f¤å¥ó"
    ActiveWorkbook.SaveAs Filename:= _
        "P:\BCM\Shipping Doc\PJ_¥X³f¤å¥ó\CI11-AX for Courier.xls", FileFormat:=xlExcel8, _
        Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
        CreateBackup:=False
¨Ò¦p:Àx¦s®æQ5ªº­È="CI11-A8"¤SÀx¦s®æH18ªº­È="PD12345",§Ú·Q­nÅý¥¨¶°¥t¦s·sÀɮɦ۰ÊÀx¦s
ÀɦW¬°:"Àx¦s®æQ5" for "Àx¦s®æH18"=>¦]¬°¬O¥Î¦b¤u§@¤W,Àx¦s®æªº­È·|¤@ª½§ïÅÜ,¦p¦ó¨ÏÀɦW¦Û°Ê
§ì¨ú«ü©wªºÀx¦s®æ©O?
¦]¬°§Ú¤£·|¼gµ{¦¡,¥u¯à¥Î¿ý¥¨¶°ªº¤è¦¡,½Ð¦b¦^ÂЮÉ,¥Î¤W¦C¿ý»s¦nªºµ{¦¡¥h­×§ï.ÁÂÁÂ.

"P:\BCM\Shipping Doc\PJ_¥X³f¤å¥ó\" & [Q5] & " for " & [H18] & ".xls"
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¶W¯Åª©¥D±z¦n,
§Ú±N§AÀ°§Ú­×¥¿¹Lªº¥¨¶°µ{¦¡¶K¤W¥h°õ¦æ¥¨¶°«á,¤@¤Á³£ok,¯u¬OÀ°¤F§Ú¤@­Ó¤j¦£.¦ý¦]¬°§Ú¦³«Ü¦h¤£¦Pªº¥¨¶°,­Y¬O§Ú±N«ü©wªºÀx¦s®æ´À´«¬°¨ä¥LªºÀx¦s®æ®É,¦³®É´N·|¥X²{¤@­Ó¹ï¸Ü®Ø:"°õ¦æ¶¥¬q¿ù»~ '1004':"...,§Ú¤£¤F¸Ñ¬°¤°»ò?§Ú·QÀx¦s®æ­n«ü©w­þ¤@­ÓÀ³¸Ó¬O¥i¥H¦Û¥Dªº,¦ý¬°¤°»ò·|¦³³o­Ó±¡§Î?ª©¥D¥i¥H¸ÑÄÀµ¹§Ú¶Ü?...ÁÂÁÂ

TOP

¦^´_ 3# PJChen


    ½Ð½T»{"P:\BCM\Shipping Doc\PJ_¥X³f¤å¥ó\"³o­Ó¸ê®Æ§¨¦s¦b
[Q5] & " for " & [H18] ©Ò²Õ¦¨ªº¦r¦êÀɦW¨Ã¥¼¨Ï¥Î¹L
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂ!À°¤F¤j¦£¤F!

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD