PDA

View Full Version : Template and SaveAsUI



DeltoidVA
01-19-2009, 10:41 AM
We use a tempalte to create workbooks for different clients. When you first click the "Save" button in a new workbook based on the master template, the SaveAsUI displays the user's default file location. What is the proper VBA code to force the SaveAsUI to a specific path that is different than the user's default file location?

xld
01-19-2009, 11:10 AM
ChDrive path_name
ChDir path_name