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

½Ð°Ý¬°¦ó·|¥X²{¥H¤U°T®§©O?

½Ð°Ý¬°¦ó·|¥X²{¥H¤U°T®§©O?

¥Ø«e¤p§Ì¦b®Ñ¼gªì¶¥VBAµ{¦¡®É,¥Î¤F¤@¨Ç¿ý»sªº¥\¯à.
¼g¤F¤@­Ó±NEXCEL¤ºªº¸ê®Æ, ¥t¦s¦¨¤å¦rÀɪº¥\¯à.
¦ý¬O·í§Ú±NVBAµ{¦¡¥[±K®É,«o¨q¥Xªþ¥ó¤§°T®§.
¦ý¬O¸Ñ±K®É«o¤S¥¿±` , ·Q°Ý¤@¤U¯uªº¬O¥[±K³y¦¨¶Ü?
­Y¬Oªº¸Ü , ¦³¿ìªk¸Ñ¨M¶Ü?

=============¥H¤W¬Ù²¤============
Output


End Sub
___________¥H¤W¬°¥t¤@­Ó¥¨¶°___________
Sub output()

OUTPUT_Folder2 = Sheet1.Range("F5")
PN2 = Sheet1.Range("F3")

    Sheets("CO GERBER").Select
    ActiveWorkbook.SaveAs Filename:=OUTPUT_Folder2 & PN2 & "-CO GERBER.prn", FileFormat _
        :=xlTextPrinter, CreateBackup:=False
===============¥H¤U¬Ù²¤==================

error message.PNG (7.75 KB)

error message.PNG

¬Ý¬Ý©ñÀɮתº¤å¥ó§¨¬O§_¦s¦b ©Î¿ù¦ì¸m
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 1# alex_wu

¤]¦³¥i¯à¬O¤w¸g¦³¦P¦W¤å¥ó¦s¦b
¦¹®É¤]·|µo¥Í¿ù»~~
¦pªG·Q­nÅý¦P¦W¤å¥ó¦s¦b®Éª½±µÂл\
¥i¥H¨Ï¥Î
on error resume next
¥t¥~¦pªG¤£·Q­n¥L¤@ª½°Ý¬O§_Âл\
´N¦A¥[¤W application.displayalerts = false
¥H¤W§Æ±æ¹ï§A¦³À°§U!

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD