Hi! I'm trying to create a batch file that opens an Excel file (successfully created in an earlier section of the batch) and Saves As a new dynamic name with the current date so that it doesn't get overwritten the next day.
I can get the file to open and close, but it's not executing the Save As. Any feedback would be greatly appreciated
set ObjExcel = CreateObject("Excel.Application")
set ObjWorkbook = ObjExcel.Workbooks.Open("\\FILELOCATION\FILENAME_.xlsx")
objExcel.Application.Visible = True
objWorkbook.SaveAs "FILELOCATION\FILENAME_" & Format(Date, "yyyymmdd") & ".xlsx"
set ObjExcel = nothing
set ObjWorkbook = nothing