Hi all once again,

Not too sure if I can explain this exactly but here goes, is it possible to have a command button with a save code attached that can generate a path & save the workbook based on an individual user account, e.g. not all staff will have the same path, would it be possible for me to ask each user to create a generic file (one that would be the same file name used nationally) in there ideal drive, then create a code to search for this particular file, wherever or whichever drive it may be? Thank you guys & have a great weekend! - Marco