Hi Could you please help me with the scenario below?
My source folder is called "Source\Files\"
It also has shortcuts folder that is shortcuts of the all original files say "Source\Shortcuts\". These shortcuts point to files in "Source\Files" folder.
----
I need to create a backup of this source folder.
We will call it "Backup\Files\"
and the new shortcut folder will be called "Backup\Shortcuts"
I want to write a macro that I will run once every month, it will check for any excel file that is updated in "Source\Files" folder, make a copy of this in "Backup\Files" and update the shortcuts in the "Backup\Shortcuts" to point to the new files.
None of the existing file names will change, however there might be new files added in "Source\Files" folder during the month.
I have researched and found macros that will copy and create a back up, but the key thing here is to only update files that have been changed or newly created, also to amend the shortcuts.
many thanks for your time and help.
regards
rinuk
My source folder is called "Source\Files\"
It also has shortcuts folder that is shortcuts of the all original files say "Source\Shortcuts\". These shortcuts point to files in "Source\Files" folder.
----
I need to create a backup of this source folder.
We will call it "Backup\Files\"
and the new shortcut folder will be called "Backup\Shortcuts"
I want to write a macro that I will run once every month, it will check for any excel file that is updated in "Source\Files" folder, make a copy of this in "Backup\Files" and update the shortcuts in the "Backup\Shortcuts" to point to the new files.
None of the existing file names will change, however there might be new files added in "Source\Files" folder during the month.
I have researched and found macros that will copy and create a back up, but the key thing here is to only update files that have been changed or newly created, also to amend the shortcuts.
many thanks for your time and help.
regards
rinuk
