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

½Ð°Ýexcel aÀɮ׸Ӧp¦ó¼gµ{¦¡©I¥sexcel b°õ¦ævba¹Bºâ«á¦^¶Ç?

½Ð°Ýexcel aÀɮ׸Ӧp¦ó¼gµ{¦¡©I¥sexcel b°õ¦ævba¹Bºâ«á¦^¶Ç?

¦U¦ì¤j¤j¦n

½Ð°Ý¦pªGexcel aÀÉ®× sheet1 a1¦³°²³]¼Æ¦r

»Ý­n¶K¤J¨ìexcel bÀɮתº sheet1 a1  ¨Ã°õ¦æSub profit_testing «á

¦A±Nexcel bªº sheet1 c1ªºµª®×¦^¶Ç¦Üexcel aªº sheet1 c1

ÁÂÁ¦U¦ì¤j¤j

¦^´_ 1# mukila
Workbooks("bÀÉ®×").Sheets(1) => bÀɮתº²Ä1­Ó§@ªí
Workbooks("bÀÉ®×").Sheets("GBKEE") => bÀɮפ¤ªºGBKEE¤u§@ªí
Workbooks("bÀÉ®×").Sheets(1).Range("A1") => bÀɮתº²Ä1­Ó§@ªí¤¤ªºA1
  1.   'aÀÉ®× bÀÉ®× ³£¶}±Ò¤¤
  2. Workbooks("bÀÉ®×").Sheets(1).Range("A1") = Workbooks("aÀÉ®×").Sheets(1).Range("A1")
  3. profit_testing
  4. Workbooks("aÀÉ®×").Sheets(1).Range("C1") = Workbooks("bÀÉ®×").Sheets(1).Range("C1")
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD