VBA打开后如何另存为带日期的文件

Question

我想保存设置为工作簿打开日期的文件，但它将此文件保存为tmp文件。我哪里错了？

Set wb = Workbooks.Open(MyFolder & "" & MyFile, UpdateLinks:=0)
MyFolder1 = "\bank.ad.pkobp.pldfsDaneGrupoweBHBPRWlasne03_Adekwatność_kapitałowa_Beata_replacement_KROK_4_COREP_ITSRoboczemacro"
wb.SaveAs (MyFolder1 & Format(Date, ddmmyyyy) & ".xls"))

Answer 1

解决方案：

Filename = "CMR_CJ_MINIMAL_"

MyFolder1＝"；xxx\xxx"wb。另存为(MyFolder1&Filename&Format(Now((；MM.YYYY"(&"；。xlsx"(