Hello,

I am hoping to have one of my userforms save a document to a shared drive called "Production". Here is my code as of right now:

dim today as string
Workbooks.add
today = Date
ActiveWorkbook.SaveAs "Q://Manufacturing/Preliminary" & today

My issue is that this is a shared workbook, so many people will be using this macro on many computers different, and not everyone has assigned the "Production" drive to the same letter, e.g. for some people it is Q drive for other people it is P drive or S drive or whatever. Is there any trick out there to working around this?