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

[µo°Ý] ¹ïÀ³¤é´Á¶K½LÂI¸ê®Æ

¦^´_ 21# n7822123
©êºp,³o­Ó«~¦W¤¤¶¡¨S¦³ªÅ®æ,¬O§Ú¥´¿ù¤F

TOP

¦^´_ 29# n7822123
¤j¤j,¤£¦n·N«ä
°õ¦æ«áÁÙ¬O³s¤@µ§¸ê®Æ³£¨S¶K¤W
¥t¥~,    iFile$ = Dir(iPath & "\*" & Keys(1) & "*.xls*")   '½T»{¬O§_¦³¦¹¨Ó·½ÀÉ
¹ê»Úªº¸ô®|¦³«Ü¦h¦P¨ÆªºÀÉ®×&Ãþ¥HªºÀɦW,
¦p¦ó¦bµ{¦¡¤¤±Æ°£¤£·Q¤ñ¹ïªºÀÉ®×?
¨Ò¦p¡G¥H¤U¤G­ÓÀÉ,¤£­n¥[¤J¤ñ¹ï¤¤ªº¸Ü,­n«ç»ò¼g¤Jµ{¦¡¤¤±Æ°£¥¦¡H
¨Î¨Î(´ò¤f¼t)®w¦sªí.xlsx
¼t¯Ê¦^õX.xlsx
0720_ªüÀs¤j¤j.rar (869.78 KB)

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2021-7-23 12:19 ½s¿è

¦^´_ 32# PJChen

°õ¦æ«áÁÙ¬O³s¤@µ§¸ê®Æ³£¨S¶K¤W

§A¥ý§O¥Î§Aªº´ú¸ÕÀÉ¡A§A¥ý¥Î§Ú¤W¦¸¤W¶Ç¸Ì­±ªº´ú¸ÕÀɬݬÝ

¦pªGÁÙ¬O¤@¼Ë¡A¨º¥i¯à¬OÀô¹Ò°ÝÃD¡A¦pªG§Úªº´ú¸ÕÀɨS°ÝÃD

¨º¥i¯à¬O§AªºÀx¦s®æ¸ê®Æ¨S¦³¬Û¹ïÀ³¡B©ÎªÌ§A¤S¦³¨ä¥LÀɮ׮榡

§Ú¤W¦¸´Nµo²{§Aªº"«~¦W"  «Ü¦³°ÝÃD

ÁÙ¦³»¡©úºÉ¶q¥Î"¹Ï¤ù"¡A¤£µM§O¤H«ÜÃøÀ´§A¦bªí¹F¤°»ò
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¦^´_ 30# °a¤ªºµ
¤j¤j¦n,

§Ú·Q¼W¥[¤@­Ó³æ¿Wµ{¦¡
±q¦U®w¦sªí¤¤,ºI¨ú"´Á¥½¼Æ¶q"
¶K¨ì¦h«È¤á½LÂIªíªºMÄæ"´Áªì"

±Ä»P¤§«eªº"¨ú½LÂI¼Æ¶q"¦P¼Ëªºµ{¦¡­ì«h
1) ·j´M¦U®wªíªº"´Á¥½"¤G¦r,¬°·j´MªºÄæ¦ì
2) ¤ñ¹ï«~¦W& «È¤á¦WºÙ
3) ¦h«È¤á½LÂIªíªºE4 & DIÄ欰§ä´M¤u§@ªíªº¨Ì¾Ú
4) ¸U¹F®w¦sªí,©ú¦~«×¶}©l¤]§ï¬°¤GÄ榡,©Ò¥H¤£¥Î¬ÝStock!
¨Ò1¡G½LÂI!E4=2021/07/13
¤ñ¹ï AÄæ«È¤á"ÂAªá"ªºDIÄæ¬OD+1,«h­n§ä
ÂAªá®w¦sªíªº"13!"

¨Ò2¡G½LÂI!E4=2021/07/13
¤ñ¹ï AÄæ«È¤á"»e¸Á"ªºDIÄæ¬OD+0,«h­n§ä
»e¸Á®w¦sªíªº"12!"
²Å¦X¥H¤W­n¥ó,«h
¶K¨ì¦h«È¤á½LÂIªíªºMÄæ"´Áªì"
    ¦h«È¤á½LÂIªí_¶ñ¤J¸ê®Æ.rar (893.64 KB)

TOP

¦^´_ 30# °a¤ªºµ
ºµ¤j¦n,
³o¦¸­«ÂI¦b´ú¸Õ´Áªì/´Á¥½¼Æ¦r.
¦A§ó·s¦Uªí®æ,¥H¤è«K´ú¸Õ
¦h«È¤á½LÂIªí_¶ñ¤J¸ê®Æ(§ó·s).rar (1.08 MB)

TOP

¦^´_ 35# PJChen
¦³ªÅ¸Õ¸Õ¬Ý§a §Ú¥u¬O§ï¤@¤U¦Ó¤w ¨S¦³­«¼g


javascript:;

Macro_1.rar (30.29 KB)

TOP

¥»©«³Ì«á¥Ñ PJChen ©ó 2021-12-8 22:49 ½s¿è

¦^´_ 36# °a¤ªºµ

ºµ¤j¦n,
§Ú¥ý´ú¸Õ¤F¤G®a,D+0 / D+1¦U´ú¸Õ¤@®a
1) »e¸Á...¬OD+0
E4=2021/07/15
À³¸Ó§ä14¤u§@ªí,¦ý«o§ä¤F13

2) ¸U¹F...¬OD+1
E4=2021/07/15
À³¸Ó§ä15¤u§@ªí,¦ý«o§ä¤F13

§Ú·QÀ³¬O§ä¤u§@ªí³W«h¿ù»~
§ä¤u§@ªí¦³©T©w³W«h....
D+0 or D+1ªº®M¥Î¦p¤U
D+0....E4¤é´Á=7/15®É+(+0)-1=15+0-1=14
D+1....E4¤é´Á=7/15®É+(+1)-1=15+1-1=15

½Ð°Ýµ{¦¡¤¤ªº³W«h­n«ç»ò§ïªk¡H

TOP

¦^´_ 37# PJChen
©êºp §ïªº®É­Ô¨S¬Ý²M·¡ ¦A¬Ý¬Ý¦³¨S¦³°ÝÃD·PÁÂ

javascript:;

Macro_1208.rar (30.11 KB)

TOP

¥»©«³Ì«á¥Ñ PJChen ©ó 2021-12-9 00:23 ½s¿è

¦^´_ 38# °a¤ªºµ

ºµ¤j¦n,
D+1³£·|§ì¨ú14¤u§@ªí,
À³¸Ó­n­n¨ú15¤u§@ªíªº¼Æ¾Ú¡I

§ä¤u§@ªí¦³©T©w³W«h....
DIÄæ D+0 or D+1ªº®M¥Î¦p¤U
DIÄæ¬O¼Æ¦r,D+0=0, D+1=1
D+0....E4¤é´Á=7/15®É+([DI]ªº­È)-1=15+0-1=14
D+1....E4¤é´Á=7/15®É+([DI]ªº­È)-1=15+1-1=15

¯à§_§âµ{¦¡§ï¦¨......+([DI]ªº­È)-1
³o¼Ë¤~·|¥¿½T

TOP

¦^´_ 39# PJChen
¦b¬Ý¬Ý§a §Ú¤Ö§PÂ_¤@­Ó ÀɦW ¨þ¨þ.. >"<


javascript:;

Macro_1_1209.rar (30.03 KB)

TOP

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD