Hi everyone,

I have created a macro that generates folders, populates them with some files and modify the files depending on what the user fills the userform with. It is working perfectly for me but not for some users that have the share-drive named under a different location. For example my share drive has been linked to X and other users to Z and Y.

How can I make the macro search for the below path if they have a different location ?

Sourcepath = "X:\Stock Divs Raleigh\EMEA\Macros - Caroline\CA docs\"
Destpath = "X:\Stock Divs Raleigh\EMEA\Events\" & SECO.Value & "-" & ISINO.Value & "-" & EvTBx.Value & "-" & Exdbx.Value & "-" & AnalystBx.Value
Thank you for taking the time to help me.