- ©«¤l
- 471
- ¥DÃD
- 121
- ºëµØ
- 0
- ¿n¤À
- 579
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-16
- ³Ì«áµn¿ý
- 2023-1-17
|
¦^´_ 4# Hsieh
ª©¥D~·Q½Ð°Ý ¦pªG·Q²¾°Ê«ü©wÀÉ®× ²¾°Ê¨ì¥t¤@¸ê®Æ§¨©O?
¦P¥Ø¿ý
ex:
¥Ø«e¨Ï¥Î¥¨¶°¬O¥H¤@Ó[ÀÉ®×1] «Ø¥ß[ÀÉ®×2]¨Ã¦Û°Ê¨ÌÀx¦s®æ¦WºÙ¦sÀɦÜ
D:\¥Ø¿ý\¶i¦æ
ÀÉ®×1.xls ActiveWorkbook.SaveAs Filename:="D:\¥Ø¿ý\¶i¦æ " & Range("B5") & "-" & Format(Range("B2"), "yyyymmddhhss") & Range("C2") & ".xlsm"
¦]§Ú¦³¦A[ÀÉ®×2]©I¥sÀɮצWºÙ¨Ã¶K¦Ü[ÀÉ®×1]AN3,·Q½Ð°Ýn«ç»òÅý¸ô®|¥i¥H¬O¥ÎŪ¨úÀx¦s®æ¨Ó°µÅÜ°Ê©O?
²¾°Ê¦Ü¥H¤U¸ô®|
«ü©wÀɦW D:\¥Ø¿ý\¶i¦æ\[AN3]
²¾°Ê¦Ü D:\¥Ø¿ý\µ²§ô |
|