Trying to link a variable to a public const

Thank you. I have over 100 client folders so will that many case statements slow down the macro? I guess there really isn't a better way to store these directories in the module.