-
August 7th, 2013, 03:00 AM
#1
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
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|