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

[µo°Ý] ½Ð¯q¡AExcel ¶}±Ò¯S©w¦~¤ë¥÷¸ê®Æ§¨¡C

[µo°Ý] ½Ð¯q¡AExcel ¶}±Ò¯S©w¦~¤ë¥÷¸ê®Æ§¨¡C

¥Ø«e¦³¼g¤@­Ó²©öªº¡A¤£¹L¥u¯à¶}±Ò«ü©wªº¸ô®|¡A¦p¤U¡C

Sub Test¡]¡^

Vba.shell "explorer.exe D:\AA\BB\CC", 1

End Sub

CC¸ê®Æ§¨¸Ì­±¦³¦~¤ë¥÷ªº¤l¸ê®Æ§¨¡A¦WºÙ¦³2021.01 & 2021.02 & 2021.03¡C¨Ì¦¹Ãþ±Àªº¤l¸ê®Æ§¨¡C
°²³]¤µ¤Ñ¤é´Á¬°2021/09/05¡Avba´N·|¦Û°Ê¶}±Ò¸ô®|¤Uªº2021.09ªº³o­Ó¤l¸ê®Æ§¨¡C

½Ð¦U¦ì¤j¤j¨ó§U¸Ñ±Ï¡AÁÂÁ¡C

¦^´_ 1# zz0660

½Ð°Ý¤@¤U¬O¤£¬O©M¤U­±³o­Ó¤@¼Ë? ÁÂÁÂ
http://forum.twbts.com/thread-23336-1-1.html

TOP

  1. Sub Test()

  2. CC = Format(Date, "yyyy.mm")
  3. VBA.Shell "explorer.exe D:\AA\BB\" & CC, 1

  4. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD