ªð¦^¦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

¨S»Ý­n±N¾ã¦C°µ®æ¦¡, ±zªºÀɮרϥνd³ò¬°[A1:V1048576], ¥B¦³·lÃa, ªþ¤W­×ÂЪ©¡C
2014_XXX_AAA.zip (27.54 KB)

TOP

¦³¨S¦³Alt+F10, ¬d¬Ý¦³§_ÁôÂ꺹Ϯ×?

TOP

¥Îexcel 2007¥H¤Wª©¥»±N³o­ÓxlsxÀÉ®×,¥t¦s¬°97-2003¾A¥ÎªºxlsÀÉ,­«·s¥´¶}³t«×·|§Ö«Ü¦h
¤£ª¾¬O§_¬O¦]¬°excel 2007¥H¤W¨Ï¥ÎÃþ¦üzip©Mxmlªº¤è¦¡¦sÀÉ

TOP

¦^´_ 11# GBKEE


    ¯u¤£·\¬O¤j¤j,¤Ó·P¿E¤F!!!!¾Ç²ß¤F!
PKKO

TOP

ExcelÀɲĤ@¦¸¶}±Ò³£·|«ÜºC
¥ý¶}¤@¦¸Ãö³¬«á¦A¶}³t«×·|ÅܧÖ
À³¸Ó¬O¨t²Î¦³cacheªº½t¬G?

TOP

¦^´_ 10# PKKO

¦¹Àɮ׶}±Ò³t«×«ÜºC¬ù8~10¬í ¬O¦]¦p¹Ï¥Ü¤¤ªº³sµ²©Ò­P

¥¼©R¦W.JPG
2014-8-8 16:45

  
ªþÀɬO§R°£­þ¨Ç³sµ²½G¨­¬° 181 KB (185,856 ¦ì¤¸²Õ)
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

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

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

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

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD