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

[µo°Ý] ¨Ï¥ÎVBA¸óÀɮקì¨ú¦h­Ó¤u§@ªí¸Ìªº¸ê®Æ

¦^´_ 1# ABK


    ¬Û«H¥H§Aªºµ{«×À³¸Ó³o¼Ë¦^´N¬Ý±oÀ´¤F¡C
½×¾Â¤º¦³¬ÛÃö½d¨Ò¥i¥H¥Î¡C
Open Excel Workbook¡A
  1. Set Wb = Workbooks.Open("\\Test\B.xlsx")
½Æ»s¥N½X
¶}±Ò²Ä¤G­ÓExcel¤è¦¡½d¨Ò
CreateObject("Scripting.Dictionary")«Ø¥ß¦r¨å¤ñ¹ï¦^¶Çµ²ªG¡C
Ãþ¦ü½d¨Ò¥i¥H°Ñ¦Ò#3
¥ý¸ÕµÛ¼g¼g¬Ý¡A¦³°ÝÃD¦AÀ°¦£­×§ï¡C

µM¦Ó§Úı±o¥ÎAccess«Ø¥ß¯Á¤Þ§ó§Ö¡A¥ÎExcel¥¨¶°µyºC¨Ç¡C
¤@¤À§V¤O¡A¤@¤À¦¬Ã¬¡C
µo°ÝÃD«e¥i¥H¥ý·j¯Á¤º¤å¬O§_¦³¬ÛÃö½d¨Ò¡C

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD