SaveAs button to location,date, and error msg.

[tp5com]

Hey all.

I'm trying to make a template for my work. I want to make a save and close button so that the users have the file saved for them in the proper location, and also so that it is properly filled out, and saved with the right file name.

So I want it to save in a certain location (C:\Here\Wherever, and save with the File Name that is specified in cell B2 (yesterdays date 'yy-mm-dd') and also not let the user save if any numbers are left in the "Outstanding" Field.



Here is the template
http://www.filefactory.com/file/848da0/n/test_xls">test.xls

thanks for any help possible