Good morning all,
I have a small programme running which requires the form to be saved after completion. It needs to be saved just by date and time, so using the following code
Code:
Application.Dialogs(xlDialogSaveAs). Show Now()
The only problem is that when the date and time are saved they have seperators which will not save ie. 07/08/13 09:01:30. I need to be able to change this to
07.08.13 09.01.30. Could somebody please show me how to do this.

Many thanks
Robbosan