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

Excelµ{¦¡¬O¥Î¨Ó°µ¤°»ò

¥»©«³Ì«á¥Ñ linshin1999 ©ó 2012-3-30 00:26 ½s¿è

µ½¥Î¿ý»s¥¨¶°±±¨î¶µ,·|±o¨ì«Ü¦hÀ°§U­ò,§Úı±o·s¤â¥i¥Ñ¦¹¤Jªù,«Ü§Ö´N¥H¦bVBAª±¥X¦Û¤vªº¤Ñ¦a¤F,¦³°ÝÃD´N¨Ó³o¸Ì°Ý,³o¸Ì¦³«Ü¦hExcellªº¦r¨å,¥ô¦ó°ÝÃD³£¥i¥H±o¨ì¸Ñµªªº.
V98

TOP

§Ú5¦~«e´N¹ïexcelµ{¦¡«Ü¦³¿³½ì
¥h®Ñ§½Â½§ä¤£¨ì§Ú¥i¥H¤Jªùªº
«á¨Ó¨â¦~«e¦b®Ñ§½¶R¤F´X¥»®Ñ¦Û¾Ç
¥D­n¬O¤½¥qªº³øªí¤Ó¦h
§Ú¤S«ÜÃi ¦]¬°³£¬O³B²z¼Æ¾Ú¤ñ¸û¦h
ªá¤Ó¦h®É¶¡¦b¾ã²z¼Æ¾Ú³oºØ¤u§@¤W¦³ÂI®ö¶O¥Í©R
©Ò¥H¤@¨B¤@¨B¾Ç
®Ñ¦h¤Ö¦³±a§Ú¤Jªù
«Ü¦h³£¬O¦bºô¸ô¤W¬Ý¨ì °Ý¨ìªº
´N¹³¤@¨Ç¤j¤j»¡ªº¦³¿³½ì«Ü­«­n
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 1# qwer7632

·íªì¬O¦Û¤w·Q°µ¤@¨Ç¦¨«~¡A©Ò¥H¦³¤@°ï¼Æ¾Ú­n¦Û°Ê³B²z¡A¤~¶}±Ò¤Fvbaªº¾Ç²ß¤§¸ô¡A¥i¥H¥ý±q¿ý»s¥¨¶°¶}©l¾Ç¡C

TOP

¦^´_ 13# yagami12th

§Ú·|¥Î¤@¨Ç¥¨¶°¡A¦ý¦b¶Ã¤C¤KÁVªº®æ¦¡¤UÁÙ¬O¥u¯à°Å¤U¶K¡A³o¤~¬O³Â·Ðªº¦a¤è
sky

TOP

¦^´_ 14# qwer7632

¾Çµ{¦¡¥»¨Ó´N¤£¬O¥ó®e©öªº¨Æ¡A¥h³Õ«È¨Ó§ä¤@¨Ç¤é¥»¤H¼gªºvba®Ñ¡A¤@¨B¤@¸}¦Lªº¬ã¨s§a¡A¤]¬O¾Ç¼gµ{¦¡¤~Åý§Ú¾Ç·|¤@¨B¤@¸}¦Lªººë¯«¡C

TOP

¦^´_ 14# qwer7632
¿ý»s¥¨¶°´Nµ¥©ó¬O§â§Aªº¾Þ§@Âà´«¦¨VBA»y¨¥
©Ò¥H¿ý»s§¹¦¨«áªº»yªk§A­n°t¦X§Aªº¾Þ§@¬yµ{¥h¤F¸Ñ³o¨Ç«ü¥O
¦A°t¦XF8³v¦æ¡A¤@¦æ¤@¦æªº°õ¦æµ{¦¡¡A°t¦X¤u§@ªí¤ºªºÅܤơA´Nª¾¹D¨º¤@¦æµ{¦¡ªº¥\¥Î
¹J¨ì¤£¤F¸Ñªº«ü¥O¡A±N·Æ¹«´å¼Ð°±¦b¸Ó«ü¥O¤W¡A«ö¤UF1´N¯à¬d¸ß¸Ó«ü¥Oªº¥Îªk
³o¬OEXCEL VBA®e©ö¤J¤âªº¥D­n­ì¦]
¨ä¥L°j°é¡B§PÂ_¦¡¡B¤@¨Ç³¯­z¦¡»yªk³£¬O©T©w¥Îªk¡A¥u¬O³o¨Ç­nÆF¬¡¹B¥Î¡A´N­n¾a¦Û¤v«ä¦Ò¤F¡C
§Ú±`¤ñ³ë¾Ç²ßVBA´N¹³°ê¤¤®É¾Ç­^¤å¡AVBA»y¨¥´N¸ò­^¤å¤@¼Ë¡A¨C­Ó«ü¥O´N¬O³æ¦r¡A»yªk´N¬O­^¤å¤åªk
¹q¸£¬O¤@¦ì¬ü°ê¤H¡A·í§Ú­Ì­n¥Î­^¤å¸ò¬ü°ê¤H·¾³q¡A´N­n³z¹L¬y§Qªº­^¤å¡A­n¦³¬y§Qªº­^¤å´N­n»{Ãѫܦh³æ¦r¡A
ºë³q¤åªk¡A¤£Â_½m²ß»¡¡A¤~¯à»¡¥X¤@¤f¬y§Q­^¤å¡C
©Ò¥H¡A¾Ç²ßVBA¤]¬O¦p¦¹¡A«ü¥O(³æ¦r)»{ÃѶV¦h¡A¤åªk(»yªk)­n¥¿½T¡A¤f¾¦(ÅÞ¿è)­n²M·¡¡A§ä¥~°ê¤H¦h½m²ß(¶Ô½m²ß)
³o¬O¾Ç²ßVBAªº¤£¤Gªkªù¡C
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

§Ú¦³¾Ç¹L«Ü¦hªF¦è¡A¦ý¨S¦³¦Ñ®v¾Çªº´NµLªk«Ü²`
¤£±`¥Î¤S·|§Ñ¦n¶Ë¸£µ¬
sky

TOP

¦^´_ 17# qwer7632

·|§Ñ ¬O¥¿±`..
¾Ç¹q¸£¬ÛÃöªF¦è(³nÅé¡BµwÅé¡Bµ{¦¡) ¥»¨Ó´N¬O¦Û¤v·Q¾Ç¤~·|¾Ç±o¦n
±j¹G§A¾Ç ¤£¨£ªº¬O¦n¨Æ
©È§Ñ°O ¥i¥H¦b§A¥´ªºµ{¦¡½X¤º+µùªþ°O
¤@¨Ó¥i¥H·í¼Ò¶ô¥Î
¤G¨Ó ¥i¥H¤Ö¥´«Ü¦h
1

µû¤À¤H¼Æ

TOP

¦^´_ 17# qwer7632


    §Ú­è¶}©l¬O¶R°ò¥»ªº®Ñ¾Ç
   ¿ý»s¦n·|±Nµ{¦¡½X¶K¨ìEXCEL¸Ì­±µM«á¤ÀÃþ
   ¤U¦¸¥Î¨ì®É§Ñ¤F«ç»ò¼g´Nª½±µ¥´¶}EXCEL¬d
   ³o¼Ë¥i¥H§Ö¨Ç
   ²{¦b¦A¦^¥h¬Ý§Ú¥H«e°OªºªF¦è
   ¯uªº¬O«Ü²Ê²L
   ¤£¹L³o¼Ë«Ü¦³¦¨´N·P
   
   ¨C­Ó¤H¾Ç²ß¤è¦¡³£¤£¤@¼Ë
   ­è¶}©l«Ü¦h«Ü²³æªºªF¦è³£¥i¥H·í§@¥Ø¼Ð
   ºCºCªº´N·|·Q­n¹³°ª¤â¤@¼Ë
   
   ¥u¦³½ñ¥X¥h¤~·|¾Ç¨ì
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¾Ç·|EXCEL¥i¥H°µ«Ü¦h¨Æ~
¹³³øªí§e²{,¸ê®Æ­p/¸Õ/Åçºâ,¤ÀªR³ø§i,µ{¦¡½sÄ¡,«Ø¥ß¼Ò«¬....µ¥
¥Î³~ÁÙÆZ¼sªº,¤]¥i¥H¥[´£¤É¤u§@®Ä²v
­Ó¤Hı±o¦bOffice®a±Ú¤¤¹ê¥Î©Ê³Ì°ª!

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD