- ©«¤l
- 354
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 387
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- vba,vb,excel2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-1-8
- ³Ì«áµn¿ý
- 2024-8-2
|
¥»©«³Ì«á¥Ñ singo1232001 ©ó 2021-12-10 16:01 ½s¿è
¦^´_ 1# jesscc
³Ì²³æªº°µªk¬O
1.¾Þ±±excel ¥t¶}¤@Ó·sÀÉ ¦s¦¨xlsx
¥t¤@Ó¤ñ¸û¥j©Çªº°µªk(¦Û¤v·Qªº)
2.§Aªº¤u§@ªí¤@¼Ë¼g¨Æ¥ó
¨Ã¥B¥Î¤@ÓÁôÂäu§@ªí¬ö¿ý2ӰѼÆ(targetªº¦ì¸m ¸ò subªº¦WºÙ)¡@¡@¡@¡@Y§A·|ÈЪ«¥óÃþ§O¼Ò²ÕÈФ]¥i¥H¥Î
¾ãӨƥ󤺪ºµ{¦¡½Xn
·h²¾¨ì¤@¯ë¼Ò²Õ«¼g¦¨¤@Ó·sªºsub¡@¡@
¦Ó¨Æ¥óIJµoÄ~Äò¯d¦b¤u§@ªí
¦ý§A¥i¯à¦³ÓºÃ°Ý
¨º¨Æ¥ó¤£´N¶]¤£°Ê¤F¶Ü?
ÁÙ¬O¯à¶] n°µ¤â¸}
¨Æ¥ó¥»¨n°µ¤@Óif °²¦p§ä¤£¨ìÁôÂäu§@ªí ¨º´Nfales
¤]´N¬O¨Æ¥ó¥Ã»·¤£·|IJµo ¦ý¤@¼Ë¥u¦³¨Æ¥ó«e¬q·|¸òµÛ¤u§@ªí ¦ý¯u¥¿ªºcode¥þ³¡¨S¦³
Y¦³µo²{ÁôÂäu§@ªí ¨Æ¥ó´N·|Ä~Äò¨«¤U¥h
´N¥Î application.run "sub¦WºÙ" Ä~Äò©I¥s³Q§A·h¨ì¤@¯ë¼Ò²Õªºsub
¦Ó³oÓ³Q¯ë¨ì¤@¯ë¼Ò²Õªºsub ·|¥h ÁôÂäu§@ªí¸Ì±§ì¨útargetªº¦ì¸m
µM«á¬Ý§A«ç»ò§Q¥Î n¦A«set¦¨ ª«¥ó¤]¥i¥H |
|