saving file to a specific folder

**naomi** · 11-13-2007, 01:43 PM

Is there a way to default my file so that anyone who goes to save will have to save to a set folder?

**Simon Lloyd** · 11-14-2007, 04:44 AM

If you add this to the thisworkbook module (Alt+F11 then double click thisworkbook) it will prevent saveas, your workbook will be saved as your workbook name along with the date and time to a specified folder, even clicking the X will cause it to save the same way.

Please Login or Register  to view this content.

replace USER for the name in your path and replace MY SAVE FOLDER for the folder name you wish it to go to!

Hope this helps!

**naomi** · 11-14-2007, 10:27 AM

Thank you very much, this does work, but is there another way to do this without using macros? I need to validate the workbook and macros make validation very messy. Do you know of a way to use a conditional IF statment ie (IF saved to incorrect file, workbook turns all text to white?) I'm just not sure of how to connect the formula to the saving process. Thanks again!