Hi Everyone,
The VBA code works with the files stored on shared drive. The path to the folders and files is defined in the VBA code as " \\server\path\folder with data\". (See extract of code below).
I have not had any issues with running VBA scripts by referencing this path before. However...