Hi all. I need to autosave a backup copy of a critical file to another location. I cannot use the default location even though the file name clearly states BACKUP and has warning messages when opened. For some reason users will still try to use those files. I have looked at file format enumerations but don't see one for backup files .XLK. How would I convert the following to use .XLK and what FileFormat?
ActiveWorkbook.SaveAs Filename:="R:\All\Level2\BACKUP\" & Nameit & ".xlsm", FileFormat:= _ xlOpenXMLWorkbookMacroEnabled, CreateBackup:=True