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

[µo°Ý] ¦h¤H¦U¦Û¨Ï¥ÎªºEXCELÀɮסA¦p¦ó¦Û°Ê§ó·sVBAµ{¦¡

[µo°Ý] ¦h¤H¦U¦Û¨Ï¥ÎªºEXCELÀɮסA¦p¦ó¦Û°Ê§ó·sVBAµ{¦¡

¨Ò¦p¡A¤½¥q­n¨C­Ó¤H¥ÎEXCEL¶ñ¤u®É³æ(­Ó¤H¨C©P¤@­ÓSHEET¨C¤ë¤@­ÓÀÉ®×)¡A¤u®É³æ¤W»Ý­n¦³¥\¯à­n¥ÎVBA¨Ó¼g¡A¦³¨Ç¥\¯à¬O³v¨B·s¼Wªº¡A¦³¨Ç¬O¼g¦n·|­×§ïªº¡C

¤@¶}©l½Æ»s A.XLS Åܦ¨ A_­û¤u½s¸¹.XLS(A_001.XLS ... A_040.XLS)¡A¦¹®É¤j®a³£¦³¤@¥÷²Ä¤@ª©ªº®æ¦¡¡B¤½¦¡¡BVBA¦Û­q¨ç¼Æ¡B¦Û­q°Æµ{¦¡¡A¦A¨Ó¦³¨Ç·s¼W©Î­×§ïªº¥\¯à­n¦p¦ó§Ö³t§ó·s¡C

½Ð¤j®a´£¨Ñ¤@¨Ç¤èªk©Î·§©Àµ¹§Ú¡A¦p¦³Â²³æ¬O½d¨Ò§ó¦n¡A¥ýÁÂÁ°ѩó°Q½×ªº¤H¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

¦^´_ 1# ML089
­Y¤H¼Æ¬Û¦P   ¸ê®Æ«¬ºA Äæ¦ì¬Û¦P±¡§Î¤U
QA1   ¥i¨Ï¥Î ¤@½d¥»ÀÉ®× ½s¼gVBA «á  ¥H¬¡­¶Ã¯¤ÀÂ÷ªº¤è¦¡¤ÀÂ÷( ¥ÒÀɮפº A B C ¤T­Ó¬¡­¶Ã¯)  Åܦ¨   A B C   ¤T­ÓÀÉ®×
QA2   ¥i¨Ï¥Î UserForm ¥Î ¤¶­±¤è¦¡ ±N ÀɮשI¥s¥X ­×§ï ·s¼W ¦A¤À§O¦sÀÉ
QA3   ¥i¥Î¸ê®Æ®w¤èªk  ±NÀɮצU¦Û¶×¤J¶×¥X

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 2# mark15jill

ÁÂÁ mark15jill ªº¦^ÂÐ

§Æ±æ¨ä¥L°ª¤â¦h´£¨Ñ¤@¨Ç¤£¦P¤èªk¡A·PÁ¤j®a
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-9-25 21:33 ½s¿è

­º¥ý³]©wÀô¹Ò

¤èªk¦³«Ü¦hºØ
§Ú³q±`¬D³Ì²³æ¤]¬O³ÌÃiªº¤è¦¡

°²³]:¤½¥q¤º¦³°Ï°ìºô¸ô...¹q¸£¸ò¹q¸£¥i¥H¦@¨É
ÅÞ¿è:
1.±Nvbaµ{¦¡¼g¦n §@¦¨.xla¼W¯q¶°.¹_°ßŪ ©ñ¦ba¹q¸£¦@¨É°Ï
2.§@¤@¤u®Éªíªº¬¡­¶Ã¯¡D¤º¦³¤@¶W³sµ²¥i³s¨ìa¹q¸£¦@¨É°Ï¶}±Ò°ßŪxla¼W¯q¶°¡@¡@¡@¤À¨É¡e¤u®Éªíªº¬¡­¶Ã¯¡fµ¹¢Ï¡þ¢Ð¡þ¢Ñ¡þ¢Ò¡þ¢Ó¡þ¢Ô¡D¡D¡D¹q¸£

Æ[©À´N¬Oµ{¦¡»P³øªí¤À¶}¨â­ÓÀÉ
©Ò¥H¥i¥H¦³«Ü¦h¤u®Éªíªº¬¡­¶Ã¯¢æ¢Ú¢áÀÉ¡@Àɮפº³£¦³¤@¶W³sµ²¡@¥i¥H¦P®É¥Ñ¢Ï¡þ¢Ð¡þ¢Ñ¡þ¢Ò¡þ¢Ó¡þ¢Ô¡D¡D¡D¹q¸£³s¨ìa¹q¸£¦@¨É°Ï¶}±Ò°ßŪxla¼W¯q¶°
Åý¢Ï¡þ¢Ð¡þ¢Ñ¡þ¢Ò¡þ¢Ó¡þ¢Ô¡D¡D¡D¹q¸£¨Ï¥Îa¹q¸£¦@¨É°Ï¶}±Ò°ßŪªºxla¼W¯q¶°
­n§ó·s¢ä¢Ð¢Ï®É¥u­n§ó·sa¹q¸£¦@¨É°Ïxla¼W¯q¶°´N¥i¥H¤F

TOP

¦^´_ 4# HUNGCHILIN


  ªü¦N¤j®v¡AÁÂÁ§A

§A´£¨Ñªº¤èªkº¡¤£¿ùªº¡A©ú¤Ñ¨ì¤½¥qºô¸ô¨t²Î´ú¸Õ¬Ý¬Ý¡C
§Aªº³¡¸¨®æ¯u¹³ª÷¤s»È¤s¡A­È±o¤é«á¦n¦n¥h«õÄ_¡C Æg
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

7¼ÓªºÀɧA¬Ý¤@¤U ©Î³\¦³¥Î

http://forum.twbts.com/viewthread.php?tid=597&highlight=hungchilin

TOP

¦^´_ 6# HUNGCHILIN

ÁÂÁ¡A³o½g¸ò§Úªº»Ý¨D«Ü±µªñ¡A¥u¬O³o´X¤Ñ¤w¸gº¡ÀɨS®É¶¡´ú¸Õ¡A¥u¯à§Q¥Î±ß¤W©Î°²¤é¨Ó´ú¸Õ¡C

µ¥´ú¸Õ§¹§Æ±æ¤U¬P´Á§A¦³ªÅ¦AÄ~Äò½Ð±Ð§A¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD