FileDrive = “C:\ANewFolder\”Filename = “Test-” & Format(Date, “mmm-dd”) & “.xls”If Len(Dir(FileDrive, vbDirectory)) = 0 ThenMkDir FileDriveEnd If
ActiveWorkbook.SaveAs Filename:=FileDrive & Filename, _FileFormat:=xlNormal
Post a Comment
No comments:
Post a Comment