Autosave as PDF in specified folder at specified time with specified name

[zebriah]

Hello, I'm new to VBA and excel but I've been stuck trying to figure out how to do what I need. I have a single excel spreadsheet named ShipTask1 that stays open always. I need to auto save at 7am and 7pm every day in a certain folder with Date_Time_ShipTask1 as the name and in PDF format. I can't have any popups happen that interrupts the excel sheet. I've looked through the forum and tried adapting several codes for autosave but none seem to do what I need without error. Thank you all for the help!

 

[zebriah]

Should this work? Again I'm new to this and have limited programing experience.

Sub AutoSave()

Dim FilePath As String
Dim FileName As String
FilePath = "C:\Users\APS1\Desktop\Maps\Daily Report\2017\August"
FileName = FilePath & Format(Date, "_", "MM-DD-YYYY") & " _ShipTask1"

If Application.OnTime = ("19:00") Then
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FileName
End If

End Sub