Mar 27 2021 08:37 PM
I am trying to find resolution to the following.
I have a folder with a macro that updates a file from another file. The path the macro uses is C:\Users\Mike\Smart Group Cayman Ltd\Smart Group Cayman Ltd Team Site - Documents.
This folder is shared with multiple users and when they want to run this macro it does not function as the path with "Mike" is incorrect.
I know some people keep the source file in dropbox so then the path can be the same but then the source file is out of the teamsites folder. Is there any way around this that would allow each user to run the macro?
Jun 30 2021 03:38 PM