I found this code in this forum and tried to modify to create a folder in F drive as “Development”
and then tried to save an excel file “Collection.xlsm” into that folder.
I am stuck and unable to move forward. Expert opinion on this is needed.
What I want to do here are as follows:
I want to check in the F drive if a folder named “Development” is present already.
If folder is not present, I want to first Create a Folder named “Development” in that F drive.
Then now I want to check in the folder “Development” if an excel file “Collection.xlsm” is present; if not present then Create the excel file “Collection.xlsm.”
If the excel file “Collection.xlsm” is present then to save the file with the current date and system time which has the format “Sunday, 30Jul2017_01-41-33 PM” added to this file and saved as “Collection Sunday, 30Jul2017_01-41-33 PM.xlsm”

Tried my best to explain it, but your valuable queries on it is welcome.....

Sub MakeMyFolder()
'MakeMyFolder Macro
Dim fsoFSO
Dim dirstr As String
Dim wb As Workbook

Set wb = ActiveWorkbook

Set fsoFSO = CreateObject("Scripting.FileSystemObject")

'Checks if folder named development exists in F drive.
If fsoFSO.FolderExists("F:\Development") Then
    wb.SaveAs "F:\Development\Collection.xlsm"
    MsgBox "Folder Exists, File Saved"
Else
    wb.SaveAs "F:\Development\Collection.xlsm"
   
    
    fsoFSO.CreateFolder ("F:\Development") 'Creates folder named development.
    MsgBox "Folder Not Found, So Created"
End If
End Sub