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

[µo°Ý] ¥¨¶°°}¦Cªºµ{¦¡

[µo°Ý] ¥¨¶°°}¦Cªºµ{¦¡

¦U¦ì¦n,

§Ú·Q¼g¤@­Ó¥¨¶°°}¦Cªºµ{¦¡,±ø¥ó¦p¤U:
±q¤u§@ªí"Shipping formula.xlsm"ªºSheet("Signed")  copy¤@­Ó¹Ï¤ù"Picture 1",¤À§O¶K¨ì
"Shipping for ACE.xlsx"ªºSheet("PKG","INV","SCD"),
¶Kªº¦ì¸m¬°Sheet("PKG")......DÄæ¦ìªº"TOTAL N. W."¦r¼Ë+¥k12®æ
                      Sheet("INV")......QÄæ¦ìªº"B. C. MART COMPANY LTD."¦r¼Ë+¤U2®æ
                      Sheet("SCD")......BÄæ¦ìªº"Signature:"¦r¼Ë+¥k2®æ

½Ð°Ý§Ú¸Ó«ç»ò°µ?

¦^´_ 2# GBKEE

Gª©¤j,
ÁÂÁ±z,¶i¦æ«Ü¶¶§Q.

TOP

¶Kñ¦WÀÉ

½Ð±Ð¦U¦ì¤j¤j:

ñ¦WÀÉ"Picture 6"©ñ¦b"Shipping formula.xlsm"ªºSheets("Signed"),
§Ú·Q±Nñ¦Wcopy¨ì("Accounting_Rising.xlsx").Sheets("INV")ªºPÄæ"RISING STAR COMPANY LTD."¦V¤U2®æ.
¥H¤U¬O§Úªº¼gªk,¦ý¤@ª½µLªk¹B§@,¥i§_À°¦£¬Ý¬Ý»yªk­þ¸Ì¦³»~?

    Windows("Shipping formula.xlsm").Activate
    Sheets("Signed").Select
    ActiveSheet.Shapes.Range(Array("Picture 6")).Select
    Selection.Copy
    With Workbooks("Accounting_Rising.xlsx").Sheets("INV").[P:P].Find("RISING STAR COMPANY LTD.").Offset(2, 0).Activate
            ActiveSheet.Paste
    End With

TOP

¦^´_ 2# GBKEE

·PÁ¤j¤j, ok¤F!

TOP

¦^´_ 2# GBKEE

½Ð°Ý¤j¤j,
¥H¤U¤GºØ¤£¦Pªº¼gªk,·|³y¦¨¿ù»~¶Ü?
§Ú·s¼W¤F 2)ªºÃ±¦W«á,¨ä¥L¦p1)ªºÃ±¦WÀÉ,¤£¬O¶Ã¶Kñ¦W2)ªºÃ±¦W,´N¬O¥X²{¿ù»~°T®§!  
ERR.jpg
2012-10-9 21:12

    1) Workbooks("Shipping formula-1.xlsm").Sheets("Signed").Pictures(3).Copy

   2)  Windows("Shipping formula-1.xlsm").Activate
    Sheets("Signed").Select
    ActiveSheet.Shapes.Range(Array("Picture 4")).Select
    Selection.Copy

TOP

¦^´_ 5# GBKEE

¤j¤j,

§Ú±Nñ¦WÀɧ󴫫á,¤£·|¥X²{¿ù»~°T®§,¦ý¤´·|¶Ã¶K,§Ú¬O¥ý¿ý»s¥¨¶°,±oª¾Ã±¦WÀɦU¦ÛªºPicture¥N¸¹¦U¦Û¬°1 & 7,¦ý©_©Çªº¬O,¥¦¤£·|¨Ì§Ú«ü©wªº¥N¸¹¥h¶K,¶K¤Wªº³£¬O7ªº¥N¸¹,§ó¥O§Ú¤£¸Ñªº¬O,­ì¥ý¥N¸¹7©|¥¼¥X²{®É,¤@¤Á³£¨S¦³²§±`µo¥Í.
Shipping formula-2.zip (106.25 KB)

TOP

¦^´_ 7# Hsieh

¤j¤j,
°õ¦æµ{¦¡«á·|¥X²{¹ï¸Ü®Ø¨Ã¥BÅã¥Ü¼Æ¦r,ÁÙ¦³Picture#,¦ýµLªkª¾¹D­þ­Ó¥N¸¹»P­þ­Óñ¦WÀɬO°t¦b¤@°_ªº!
¥t¥~´N¬O¥u¦³¤G­Óñ¦W,¥i¬O¬°¤°»ò¹ï¸Ü®Ø¥X²{4¦¸?

TOP

¦^´_ 8# GBKEE

G¤j,
°õ¦æµ{¦¡«á,·|¦bñ¦WÀɤW¥X²{¬ÛÀ³ªºPicture¥N½X,³oÃÒ¹ê§Ú­ì¥ý³]ªº¥N½X¤]¨S¿ù,¥i¬O·|¶Ã¶Kªº­ì¦]¬O¤°»ò?¬O§_¤G­Ó¶Kñ¦Wªºµ{¦¡¦³½Ä¬ðªº¦a¤è?¾É­P¶Ã¶Kñ¦WÀÉ?
¥t¥~·Q½Ð±Ð¨C©ñ¤@­Óñ¦WÀɳ£·|¦Û°Ê²£¥Í¥¦¦Û¤vªº¥N¸¹,¦ý¥N¸¹¬O§_¥i¥H§ó§ï?

Shipping formula-2.zip (110.25 KB)

TOP

¦^´_ 11# Hsieh

¤j¤j,

«ü©w¹Ï¤ù§Ç¸¹ or «ü©w¹Ï¤ù¦WºÙ ¦³¤°»ò¤£¦P¶Ü?³o¤G­Óñ¦W,¤@­Ó¬OPicture 1,¤@­Ó¬OPicture 7,°ÝÃD¦b©ó§Ú«ü©w¤F,¦ý·|¶Ã¶K,§Ú¸Ó¦p¦ó­×¥¿µ{¦¡¶Ü?

TOP

¦^´_ 11# Hsieh

¸É¥R:
¦pªG§Ú·Q¥H"«ü©w¹Ï¤ù¦WºÙ"¨Ó¼gµ{¦¡,¥¦¨Ã¤£±µ¨ü.
Workbooks("Shipping formula-2.xlsm").Sheets("Signed")."Picture 1".Copy

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD