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

[µo°Ý] excel¥~³¡¸ê®Æ³sµ²»Pvba°õ¦æ¶¶¦ì

[µo°Ý] excel¥~³¡¸ê®Æ³sµ²»Pvba°õ¦æ¶¶¦ì

½Ð°Ý²{¦b¦³¨â­ÓÀɮסA¥Ò¬O¸ê®Æ®w¡A¤A¬O¨Ï¥ÎªÌ
¤A¥Îmicrosoft query°µ¥~³¡¸ê®Æ³sµ²
¤Aªºsheet1.[a1]¬O¨Ï¥ÎªÌkey in¬d¸ß叁¼Æ¡Asheet2¬O¬d¸ß«áªº¸ê®Æ

²{¦b°ÝÃD¬O¡A¬d¸ß«á¦³¼gµ{¦¡½X±N¸ê®Æ¼g¤Jsheet1¡A¦ýmicrosoft query¥~³¡¸ê®Æ³sµ²¦n¹³¶·µ¥¨ìvba¶]§¹«á¡A¤~·|¶×¤J¸ê®Æ
(§Úª¾¹D¥i¥H¨Ï¥Î=ªº¨ç¼Æ¡A¦ý¦]¤u§@³õ©Ò°ÝÃD¡A¤£·Q¨Ï¨ç¼Æ)
³o¼ËµLªk¤Î®É±N¬d¸ß«á¸ê®Æ¼g¶isheet1


½Ð¦U¦ì¤j¤j­ÌÀ°¦£¸Ñµª¡AÁÂÁÂ~

123.rar (32.17 KB)

¦^´_ 1# swtseng
­×§ï ¬d¸ß¥~³¡¸ê®Æªº BackgroundQuery ÄÝ©Ê ¬° False :  ¤£¦b­I´º°õ¦æ°õ¦æ
¦pªG¼Ï¯Ã¤ÀªRªí³øªí©Î¬d¸ßªíªº¬d¸ß¬O¦b«D¦P¨B¼Ò¦¡°õ¦æ (¦b­I´º°õ¦æ) ªº«h¬° True¡CŪ/¼g Boolean¡C

¦p¹Ï ¤£¤Ä¿ï


TOP

·PÁ±zªº¼ö¤ßÀ°§U

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD