Force File Name Convention

[AD108]

Is there a way to force a user to save a file in a certain format.

For example the only way they would be able to save the file would be as a
date in the following format. 12-12-05

[Bob Phillips]

Here is one way that saves it as today's date when closed,

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.SaveAs Format(Date, "dd-mm-yy")
End Sub
'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code

but you probably need to give more details on when you wan t this to happen,
what rules determine that date, etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"AD108" <[email protected]> wrote in message
news:%[email protected]...
> Is there a way to force a user to save a file in a certain format.
>
> For example the only way they would be able to save the file would be as a
> date in the following format. 12-12-05
>
>

[AD108]

Thanks alot, looks like a good lead for what I am working on.
"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> Here is one way that saves it as today's date when closed,
>
> Private Sub Workbook_BeforeClose(Cancel As Boolean)
> ThisWorkbook.SaveAs Format(Date, "dd-mm-yy")
> End Sub
> 'This is workbook event code.
> 'To input this code, right click on the Excel icon on the worksheet
> '(or next to the File menu if you maximise your workbooks),
> 'select View Code from the menu, and paste the code
>
> but you probably need to give more details on when you wan t this to
happen,
> what rules determine that date, etc.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "AD108" <[email protected]> wrote in message
> news:%[email protected]...
> > Is there a way to force a user to save a file in a certain format.
> >
> > For example the only way they would be able to save the file would be as
a
> > date in the following format. 12-12-05
> >
> >
>
>