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

[µo°Ý] ¥ÑÀɮפ@ªº«ö¶s¥h°õ¦æÀɮפGªº¥¨¶°

[µo°Ý] ¥ÑÀɮפ@ªº«ö¶s¥h°õ¦æÀɮפGªº¥¨¶°

½Ð°Ý¦U¦ì«e½ú,
¤p§Ì¥Ø«e¦b¤u§@¤W¹J¨ì¤@­ÓÃøÃD

¦³¨â­ÓÀɮפÀ§O¬O a.xls , b.xls , ­ì¥»´N¤K¬ñ¤l¥´¤£µÛªºªF¦è©Ò¥H¦U¦Û¦³¦U¦Ûªº¥¨¶°³B²z¸ê®Æ

¦ý¬O²{¦b¦]¦ÑÁó»Ý­n,²{¦b­n±qa.xls ¤ºªº²³¦h¤u§@­¶¤ºªº¸ê®Æ,¦pªG¸òb.xls ªº sheets("form")¤º¦³²Å¦Xªº«K¶ñ¤J

§Úªº·Qªk¬O¦bb.xls ·s¼W¤@Äæ¦ì¥Î¨Ó¹ï·Óa.xls ªº¤u§@­¶
µM«á¦ba.xls ¤W«Ø¤@«ö¶s,·í«ö¤U«ö¶s®É«K¨Ì·ÓÄæ¦ì¤W©Ò¶ñªº¤u§@­¶¦W¦r,¥h·j´Ma.xls ªº¯S©w¤u§@­¶¤ºªº­È
¦pªG¦³²Å¦X­Èªº´N¶ñ¤Jb.xls ­ÈªºÄæ¦ì

¦ý¬O¤p§Ì¹J¨ìªº¬O±q¨S¼g¹LÀɮ׬ÛÃöªº³B²z¤è¦¡
¸ê®Æ³B²zªº¥¨¶°À³¸Ó¬O¼g¦bb.xls¤º
§Ú¦ba.xls«ö¤U«ö¶s­n¦p¦ó¥h°õ¦æb.xls¤ºªº¥¨¶°©O??
¦Ób.xls ªº¥¨¶°¥i¥H·j´M a.xls ªº¸ê®Æ
ps. ¦b¤£¶}±Òb.xls Àɮתº±¡ªp¤U

½Ð¤j¤jÀ°¦£,¤p§Ì·P¿E¤£ºÉ

¦^´_ 1# a703130


    ¦pªG·Q¹B¦æbªº¥¨¶°, ´N±o­n¥´¶}bªºxls,
¦ý¥i¥H¦b¹B¦æ«á¦Û°Ê§âb.xlsÃö±¼.

¥t¤@¤è, Ãö©óa¥¨¶°¦pªG¹B¦æbªº¥¨¶°
¥ý§âb ªº¥¨¶°, ©ñ¦bthisworkbook¤§¤º.
¦ba¥¨¶°:

set wb= workbooks.open("b.xls")
wb.¥¨¶°¦W(°Ñ¼Æ)
...
wb.close(false)
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

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

TOP

¥»©«³Ì«á¥Ñ a703130 ©ó 2012-10-24 09:09 ½s¿è

¦^´_ 2# kimbal


ÁÂÁ¤j¤j´£¨Ñªº¤èªk~§Ú·|¹Á¸Õ¨Ï¥Î

TOP

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD