- ©«¤l
- 40
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 62
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-12-27
- ³Ì«áµn¿ý
- 2014-11-18
|
¤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§Ì¥un§ì¨ú¤½¦¡«áªºÈ¦Ó¤w
©Ò¥H·Q½Ð°Ý¤@¤U ¦³¨S¦³¥u¨úȦӤ£§ì¨ú¤½¦¡ªº¨ç¼Æ©O ?
³Â·Ð½Ð±Ð¦U¦ì¤F!! |
|