August 7th, 2013, 03:00 AM
change of seperator when using SaveAs, instead of 07/08/13 it needs to be 07.08.13
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
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
Application.Dialogs(xlDialogSaveAs). Show Now()
07.08.13 09.01.30. Could somebody please show me how to do this.
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.