Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
'Save file to FName2 Application.DisplayAlerts = False 'use if overwritting file to nix popup Dim FName2 As String ' L-learned do not use lettered drives FName2 = "\\na\Global-Groups\Holland\Operations\Logistics\DSC\Go to Work Signals\RePlan Report\AM PM RePlan Report " FName2 = FName2 & Format(Date, "yyyy.mm.dd") & " " & Format(Time, "hhmm") & ".xlsx" ActiveWorkbook.SaveAs Filename:= _ FName2, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False ActiveWorkbook.Close
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.