Building macro that multiple user on teamsites can use

%3CLINGO-SUB%20id%3D%22lingo-sub-2240113%22%20slang%3D%22en-US%22%3EBuilding%20macro%20that%20multiple%20user%20on%20teamsites%20can%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2240113%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20find%20resolution%20to%20the%20following.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20folder%20with%20a%20macro%20that%20updates%20a%20file%20from%20another%20file.%20The%20path%20the%20macro%20uses%20is%26nbsp%3BC%3A%5CUsers%5CMike%5CSmart%20Group%20Cayman%20Ltd%5CSmart%20Group%20Cayman%20Ltd%20Team%20Site%20-%20Documents.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20folder%20is%20shared%20with%20multiple%20users%20and%20when%20they%20want%20to%20run%20this%20macro%20it%20does%20not%20function%20as%20the%20path%20with%20%22Mike%22%20is%20incorrect.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20some%20people%20keep%20the%20source%20file%20in%20dropbox%20so%20then%20the%20path%20can%20be%20the%20same%20but%20then%20the%20source%20file%20is%20out%20of%20the%20teamsites%20folder.%20Is%20there%20any%20way%20around%20this%20that%20would%20allow%20each%20user%20to%20run%20the%20macro%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2240113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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?

0 Replies