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

Ãö©ó¸óÀɮ׽ƻs­È¸Ó¦p¦ó¨Ï¥Îwindows

Ãö©ó¸óÀɮ׽ƻs­È¸Ó¦p¦ó¨Ï¥Îwindows

·Q­n±N¥Ø«e­¶­±ªºA3­È ½Æ»s¨ìª`·N¨Æ¶µ¤ºªºD2
¦ý¬ÒµLªk¦¨¥\

Range("A3").Copy windows("ª`·N¨Æ¶µ.xls").sheets("¤u§@ªí1").Range("D2")

¦^´_ 1# starry1314



    Range("A3").Copy workbooks("ª`·N¨Æ¶µ.xls").sheets("¤u§@ªí1").Range("D2") 'windows ¤£¯à, ½Ð§ï¥Îworkbooks

TOP

¦^´_ 2# ikboy


    ÁÂÁ±оÇ~¦]¥Î¿ý»sªº¦A¤Á´«µøµ¡³£¬Owindows ´N¥d¦º¦b³o¤F

TOP

§Úªº¤èªk¤ñ¸û²Â

Workbooks(AAA).Activate
Workbooks(BBB).Activate

¦b¨â­ÓÀɮפ§¶¡¤Á´«¡A§Ú´N¥Î³o­Ó¡C

TOP

¦^´_ 4# vanguarx
¶â¶â~§Ú­ì¥»¤]¬O¥Î³o¼Ëwindows¤Á´«¨Ó¤Á´«¥h,
¦]·Q¼gªºÂ²³æÂI ¦ý´N¬O¥d¦º

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD