ç»ä½ ååï¼
Sub aaa()
'è·åå½åå·¥ä½ç°¿ä¸å¸¦åç¼çå称
A = Left(ThisWorkbook.Name, InStr(ThisWorkbook.Name, ".") - 1)
'å¦å¤ä¸ä¸ª
æ件夹ï¼å设æ¯cçä¸æ件夹aaï¼ä½ èªå·±æ¹
path1 = "C:\aa\"
'åå¾æ¥æï¼å°æ¥æä¸ç/åæ.
dat = Replace(Date, "/", ".")
ThisWorkbook.SaveAs path1 & A & Date & ".xls"
End Sub
追é®å¯æ¯æåæ¥çå·¥ä½ç°¿å称为181333.101æ件.xlsï¼å称å½ä¸æ2个â.â,ä¸ç¥éæä¹å¤çäºï¼
追çSub aaa()
'è·åå½åå·¥ä½ç°¿ä¸å¸¦åç¼çå称
A = Left(ThisWorkbook.Name, InStrrev(ThisWorkbook.Name, "."))
'å¦å¤ä¸ä¸ªæ件夹ï¼å设æ¯cçä¸æ件夹aaï¼ä½ èªå·±æ¹
path1 = "C:\aa\"
'åå¾æ¥æï¼å°æ¥æä¸ç/åæ.
dat = Replace(Date, "/", ".")
ThisWorkbook.SaveAs path1 & A & dat & ".xls"
End Sub