Trying to link a variable to a public const

Hello there,

Can you please add code tags around you post? Also, what values will be entered into the text box? For instance what is entered into the textbox to make the variable location equal to Public Const Tim= "G:\Users\Tim\" and so on?

Thanks!

I will be entering a client name into the inputbox & using that name in the save as string (saving the pdf as "client name 1/2/3/4 Q Account Overview". So basically, the client name I type into the inputbox has two functions. 1. used in save as string and 2. used to determine which file location that client should be saved to based on the public const I set up for each client. Each client has a different file location (separate folder) & I am trying to be able to type just a client name & my macro will save it in the correct folder. Thanks