SaveAs button to location,date, and error msg.

tp5com

New Member
Joined
Jul 18, 2008
Messages
1
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
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Watch MrExcel Video

Forum statistics

Threads
1,122,815
Messages
5,598,259
Members
414,220
Latest member
Nations

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top