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

½Ð°Ý¬°¤°»ò°õVBA®É¡A°O¾ÐÅé·|¶V¨Ó¶V¤j¡AÅܦ¨³t«×ÅܺC

¦^´_ 1# ashin1981
¤@¨Ç¬O¥Îexecelªºweb¥\¯à¥h¤U¸ü«á³B²z

¥Î§¹ªºWeb³s½u¦³§R°£¶Ü? (¸ê®Æ>³s½u)
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

¦^´_ 5# ashin1981
«Øij¦³¥Î¨ì QueryTables ªº¦a¤è
³£¦b .Refresh BackgroundQuery:=False
ªº¤U¤è¦h¤@¦æ .Delete  ¨Ó§R°£³s½u
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD