- ©«¤l
- 122
- ¥DÃD
- 26
- ºëµØ
- 0
- ¿n¤À
- 148
- ÂI¦W
- 0
- §@·~¨t²Î
- windos10
- ³nÅ骩¥»
- office2016
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2021-7-8
- ³Ì«áµn¿ý
- 2023-8-28
|
¦^´_ 7# cowww
½Ð°Ý³o¬q§PÂ_¦¡þ¸Ì¼g¿ù¤F
§Ú§Æ±æ¨t²Î¥ý¥h§ä·í¤Ñ¤é´Áªº²§°Êªí¡A¥i¬O¥¦³£¬O¥h§ä¬Q¤Ñªº¤é´Á
¦pªG"¦³"->°õ¦æIf
¦pªG"¨S¦³"->¦AElse
A = Format(Date, "W")
If B = Format(Date, "yyyy.mm.dd") Then
Workbooks.Open ("\\shl-group.com\dept\MFMG\B.¦U²Õ¸ê®Æ (Team inform)\E.¥ÍºÞ²Õ (PPC group)\D.¥Í²£¬ÛÃö\2.¨C¤é¼Ò¨ã²§°Ê\¼Ò¨ã²§°Ê-¤»ºÖ\" & B & " ¨C¤é¼Ò¨ã²§°Ê.xlsx")
Else: B = Format(Switch(A = 7, Date - 1, A = 1, Date - 2, A = 2, Date - 3, A > 2, Date - 1), "yyyy.mm.dd")
Workbooks.Open ("\\shl-group.com\dept\MFMG\B.¦U²Õ¸ê®Æ (Team inform)\E.¥ÍºÞ²Õ (PPC group)\D.¥Í²£¬ÛÃö\2.¨C¤é¼Ò¨ã²§°Ê\¼Ò¨ã²§°Ê-¤»ºÖ\" & B & " ¨C¤é¼Ò¨ã²§°Ê.xlsx") |
|