如何在文件夹内自动生成文档目录,形成excel表,只要修改日期和文件名,两个要素要分开两列

2024-11-24 00:31:23
推荐回答(4个)
回答1:

要用VBA
在THISWORKBOOK代码窗口:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ActiveWorkbook.SaveAs ActiveWorkbook.Path & "\报表-" & FOMAT(Now(), "yyyy.mm.dd.hh.mm")
End Sub

回答2:

ActiveWorkbook.SaveAs ActiveWorkbook.Path & "\报表-" & FOMAT(Now(), "yyyy.mm.dd.hh.mm")

回答3:

我也不是很清楚啊

回答4:

写代码可以实现,具体要看你的文件