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

QueryTables­«½Æ¬d¸ß¡A¦p¦óÂл\¤W¤@µ§¬d¸ß

¦^´_ 1# tsunamix03

¦bµ{¦¡½X¶×¤J¬d¸ß®É,«ü©w³oÄݩʪº°Ñ¼Æ­È
  1. .RefreshStyle = xlOverwriteCells
½Æ»s¥N½X
VBA ªº»¡©ú
  1. RefreshStyle ÄÝ©Ê
  2. ½Ð°Ñ¾\®M¥Î¦Ü½d¨Ò¯S©w¶Ç¦^©ÎªÌ³]©w«ü©w¤u§@ªí¤¤¦Cªº´¡¤J©Î§R°£¼Ò¦¡¡A¥H´£¨Ñ¬d¸ß¶Ç¦^ªº°O¿ý¶°ªº¦C¼Æ¡CŪ/¼g XlCellInsertionMode¡C

  3. XlCellInsertionMode ¥i¥H¬O³o¨Ç XlCellInsertionMode ±`¼Æ¤§¤@¡C
  4. xlInsertDeleteCells¡C´¡¤J©ÎªÌ§R°£³¡¥÷¦C¥H¾AÀ³·s°O¿ý¶°©Ò»Ý­nªº¹ê»Ú¦C¼Æ¡C
  5. xlOverwriteCells¡C¤£¦b¤u§@ªí¤¤·s¼W·sªºÀx¦s®æ©Î¦C¡C¦pªG·¸¥X«h¨ú¥N©P³òªºÀx¦s®æªº¤º®e¡C
  6. xlInsertEntireRows¡C·s¼W¸ê®Æ recordset ¤¤ªº©Ò¦³¦C¡A¨Ã¥B¤¹³\·¸¥X­ì¦³°Ï°ì¡C¤u§@ªí¤¤¨S¦³³Q§R°£ªºÀx¦s®æ©Î¦C¡C
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD