Marco to save file at a specific time and location

[excelisland]

Hi,

I need a macro that saves and closes file at a specific time and to a specific location. For example, I would want the macro to run automatically at 1 AM, save the file to a particular folder, and then close the file.

Thanks

[ranman256]

something like this: