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

[µo°Ý] §ì¨ú¤½¦¡¤¤ªº­È

[µo°Ý] §ì¨ú¤½¦¡¤¤ªº­È

¤p§Ì·Q½Ð°Ý¤@¤U

¤p§Ì¤µ¤Ñ¦bBOOK1.xlsªºHello¤¤    §ì¨úBOOK2.xls¤¤ªºGOOBYEªºcells( 1 , 1 ) ¦Ü   Helloªºcells( 2, 2 )

¦ýBOOK2.xls ¤¤ªºSHEET2 ªº cells( 1 , 1 ) ¬OEXCELªº¤½¦¡ EX: =MIN(F6:F76)

¤p§Ì¼gªº³¡¥÷µ{¦¡

   Application.ScreenUpdating = False
   Application.DisplayAlerts = False
   Workbooks.Open "C:\Documents and Settings\host\®à­±\BOOK2.xls"
   Workbooks("BOOK2.xls").Sheets("GOOBYE").Cells(1, 1).Copy  Workbooks("BOOK1.xls").Sheets("GOOBYE").Cells(2, 2)
   Workbooks("BOOK2.xls").Close
   Application.ScreenUpdating = True
   Application.DisplayAlerts = True

   ¤p§Ì¦¨¥\§ì¨ú«á  µo²{¤½¦¡¤]·|¤@¨Ã³Q§ì¨ú
   ¦ý¤p§Ì¥u­n§ì¨ú¤½¦¡«áªº­È¦Ó¤w
   ©Ò¥H·Q½Ð°Ý¤@¤U  ¦³¨S¦³¥u¨ú­È¦Ó¤£§ì¨ú¤½¦¡ªº¨ç¼Æ©O ?
   ³Â·Ð½Ð±Ð¦U¦ì¤F!!
WOW

¦^´_ 1# g93353

½Æ»s¥þ³¡
Workbooks("BOOK2.xls").Sheets("GOOBYE").Cells(1, 1).Copy  Workbooks("BOOK1.xls").Sheets("GOOBYE").Cells(2, 2)

½Æ»s­È
Workbooks("BOOK1.xls").Sheets("GOOBYE").Cells(2, 2)=Workbooks("BOOK2.xls").Sheets("GOOBYE").Cells(1, 1)

TOP

¤À¨â¦æ
Workbooks("BOOK2.xls").Sheets("GOOBYE").Cells(1, 1).Copy
Workbooks("BOOK1.xls").Sheets("GOOBYE").Cells(2, 2).PasteSpecial Paste:=xlPasteValues

°Ñ¦Ò¤@¤U ¿ï¾Ü©Ê¶K¤W->­È, ³o­Ó¥\¯à¬Û·í¦³¥Î.
·íµM¤]¥i¥Îregister313¥SªºÂ²³æ¤èªk
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

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

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD