Hi everyone. I’ve probably missed something obvious with the SaveCopyAs command, but what I’m looking to do is autosave a copy of files to a backup folder - same file name and all, just a copy.
For example, if there’s a file in “C:\Monthly Sales” for “October 2024 Sales - John Smith.xlsm,” I want a copy of that file autosaved in “C:\Backup Sales” (while overwriting any previously saved files). This would be the same for almost 100 other users logging their sales.
Again, I’m probably missing something simple, but thanks in advance!
For example, if there’s a file in “C:\Monthly Sales” for “October 2024 Sales - John Smith.xlsm,” I want a copy of that file autosaved in “C:\Backup Sales” (while overwriting any previously saved files). This would be the same for almost 100 other users logging their sales.
Again, I’m probably missing something simple, but thanks in advance!