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

[µo°Ý] vba¥i§_¤£¥´¶}excelªí§Y¥iª¾¹Da1ªº­È?

[µo°Ý] vba¥i§_¤£¥´¶}excelªí§Y¥iª¾¹Da1ªº­È?

¦]¬°¤º«Ø¨ç¼Æ¥i¥H=   =AY10-'C:\OneDrive\XX\1XXÁ~¸ê®Öºâ¨t²Î\XX©±\4-XX³æ¦ì\[XX_·~°È¥DºÞªA°È¶O.xlsm]XX¦~«×7¤ë¥÷'!$BB$71
³o­Ó¨ç¼Æ¤]¬O§Ú³z¹Lvba¦Û°Êµ¹¥Lªº

¬JµM¨ç¼Æ¥i¥H¤£¥´¶}excelªí§Y¥iª¾¹D³Ì·sªº­È
¨ºvba¬O§_¤]¯à¿ì¨ì~ "¤£¥Î¥´¶}excelªí,´N¥i¥Hª¾¹D¸Óªía1Àx¦s®æªº­È©O"
PKKO

¦^´_ 1# PKKO
MsgBox Application.ExecuteExcel4Macro("'C:\OneDrive\XX\1XXÁ~¸ê®Öºâ¨t²Î\XX©±\4-XX³æ¦ì\[XX_·~°È¥DºÞªA°È¶O.xlsm]XX¦~«×7¤ë¥÷'!" & Range("$BB$71").Address(true,true,xlR1C1)

TOP

¦^´_ 2# stillfish00

·PÁÂ,¤w¸g·|¨Ï¥Î¤F

¥i§_¦A½Ð±Ð¤@¨ÇÅܤÆÃD,¦P¼Ë³£¤£¶}±ÒEXCELªí
EX:
1.¶i¦æ½d³ò½Æ»s
2.°»´ú½d³òÀx¦s®æ¤º´X­ÓÀx¦s®æ¦³­È(Ãþ¦üCOUNTA¨ç¼Æªº¥\¯à)

¤£¦n·N«ä,³Â·Ð¤j¤j¤F
PKKO

TOP

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2014-8-1 15:36 ½s¿è

¦^´_ 3# PKKO
¤£·|¡A³o¤£¬O¤@¯ëªºVBA¬yµ{¡A
¬°¦ó¤£¦Û°Ê¶}±Ò³B²z§¹«á¦AÃö³¬¡C

¦pªG§A¬O·Q§âexcelÀÉ·í¦¨¸ê®Æ®w¦s¨ú¡A¨º¤S¬O¥t¥~¤@¦^¨Æ¤F

TOP

¦]¬°¦³­Ó³øªí,­n¥ý°Ñ·Ó¤H¦W,¦A¨Ì¾Ú¤H¦WªºÀÉ®×Ū¨ú¬ÛÃö¸ê°T
¦ý¤H¦W²³¦h,­Y¨C­ÓÀɮ׳£¶},§Ú¾á¤ß·|­°§C³t«×
¦]¦¹¤j¤j±z´£¨Ñªº¤èªk«D±`¤è«K
¤£¶·¶}±ÒÀɮתº¸Ü,§Ú·Q³t«×·|§Ö³\¦h

¦ý«á¨Óµo²{¦³¤@¥÷³øªí,¶}±ÒÀɮ׳t«×·¥ºC(¬ù¥|¤Q¬í)
¤~·Q»¡¬O§_¥i¥H½d³ò°Ñ·Ó,¨þ¨þ
¤j¤j±z¤w¸gÀ°³\¦h¦£Åo!ÁÂÁÂ!
PKKO

TOP

¦^´_ 5# PKKO


   
§Ú·Q©Ò¦³ªºEXCELÀɮ׳£¬O·|¶}±Ò¦b°õ¦æªº,¥u¬O¥¦¤£·|Åã¥Ü¥X¨Ó
©Ò¥H¦pªGÀɮ׫ܤjªº¸Ü,ÁÙ¬O·|»Ý­n°õ¦æªº®É¶¡
¤j®a¤¬¬ÛÀ°¦£¸Ñ¨M°ÝÃD,¤~·|¶i¨B

TOP

À³¸Ó´N¬O¦p¦Pvisible=false¤£Åã¥Ü¥X¨Óªº·N«ä?
¦ý¬O¤u§@ºÞ²z­ûÁÙ¬O·|¥X²{excel.exeªºµ{§Ç§a?

TOP

¦]¬°¤£ª¾¦óºØ­ì¦],¦¹Àɮ׶}±Ò³t«×«ÜºC¬ù8~10¬í

§Ú¤w¸g§â¨ä¥L¦h¾lªºSHEET³£§R°£¤F

·Q½Ð±Ð°ª¤â,¦¹Àɮ׬°¦ó·|³o»ò¤j?¥¼À£ÁY«e2.5M

¨S¬Æ»ò¤½¦¡ªü= = 2014_XXX_AAA.rar (997.16 KB)
PKKO

TOP

1. ¬Ý¬Ý¦³¨S¦³ÁôÂêº sheet?
2. ¼Ë¦¡¬O§_¹L¦h?
3. ¦pªG¬O xls Àɪº¸Ü, ¥i¥H¥ýÂà¦s¦¨ xlsx ©Î xlsm , ¦AÂà¦s¦^ xls

TOP

§Ú¤w¸g±NÁôÂ꺳£§R°£¤F
§Ú¤£·QÂন¨ä¥LªºÀÉ®×,¦ý§Ú·Qª¾¹D¬°¦ó³oÀɮ׳o»ò¤jªº­ì¦]
°w¹ï­ì¦]³B²z
¦]¬°³o¤£¬O§Ú­Ó¤H¨Ï¥Îªº¤å¥ó
¥²¶·¦bª¾¹D­ì¦]ªº±¡ªp¤U³B²z«D¥²­nªº³¡¤À
PKKO

TOP

        ÀR«ä¦Û¦b : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD