I have developed a workbook that relies on information from other Files and
folders from 'My Documents'
For example there is a macro that runs to save a copy of the workbook as a
backup into the 'Backups Folder', but if the Folder is not present the macro
will return an error.
Another macro when it is run will update the current workbook from another
file called 'Updates'.
The problem I have is that the same set of Files and folders is located on
field staffs laptops, and they have a habit of (I dont know how) losing some
of the files.
So I need a code that can check that all the files and folders are in place
and in the correct location. If not it would come back with a message to say
what files are missing.
Any help greatly appreciated
John