或者有什么方法能用B5(图)单元格重命名Excel文件(直接使用会提示有特殊符号)
如下是试着编写程序:
Sub Macro1()
Application.ScreenUpdating = False
Dim Xls
Xls = Dir("C:\Users\Administrator\Desktop\mpimpimpi" & "\*.csv")
Do While Xls <> ""
Set Xls = Workbooks.Open("C:\Users\Administrator\Desktop\mpimpimpi" & "\" & Xls)
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Administrator\Desktop\mpimpimpi\ling\mpi" & Format(Sheets(1).Range("C9")) & Format(Date, "yyyymmdd") & Format(Time, "hhmm") & ".csv"
ActiveWorkbook.Close
Xls = Dir
Loop
Set Xls = Nothing
End Sub
这段程序只能是把当前时间作为文件名的一部分,![](http://imgsrc.baidu.com/forum/w%3D580/sign=253bcc5a8526cffc692abfba89004a7d/721bd23f8794a4c2ef605de809f41bd5af6e39c1.jpg)
![](http://imgsrc.baidu.com/forum/w%3D580/sign=9a42ff3c3cc79f3d8fe1e4388aa0cdbc/5969a951f3deb48fdf2b1b1df71f3a292ff578c2.jpg)
如下是试着编写程序:
Sub Macro1()
Application.ScreenUpdating = False
Dim Xls
Xls = Dir("C:\Users\Administrator\Desktop\mpimpimpi" & "\*.csv")
Do While Xls <> ""
Set Xls = Workbooks.Open("C:\Users\Administrator\Desktop\mpimpimpi" & "\" & Xls)
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Administrator\Desktop\mpimpimpi\ling\mpi" & Format(Sheets(1).Range("C9")) & Format(Date, "yyyymmdd") & Format(Time, "hhmm") & ".csv"
ActiveWorkbook.Close
Xls = Dir
Loop
Set Xls = Nothing
End Sub
这段程序只能是把当前时间作为文件名的一部分,
![](http://imgsrc.baidu.com/forum/w%3D580/sign=253bcc5a8526cffc692abfba89004a7d/721bd23f8794a4c2ef605de809f41bd5af6e39c1.jpg)
![](http://imgsrc.baidu.com/forum/w%3D580/sign=9a42ff3c3cc79f3d8fe1e4388aa0cdbc/5969a951f3deb48fdf2b1b1df71f3a292ff578c2.jpg)