Excel Document that creates new excel documents monthly

[Ajaxs87]

Hi,

I was trying to make an excel document that creates a new copy of document templates I have monthly. I have three attachments:
The first one (Monthly File Reset) has a few formulas to dictate how the file name should be written and the other two are more or less blank templates for reference for the process.

What I have envisioned.
- Cells B1 & C1 = are the now() function and will change month to month and year to year, respectively.
- A5 & A6 = Are the Filenames
- A12 & A13 are concatenate formulas of Filenames, b1 & c1

I am seeking to have a formula that when opened, looks at a folder location, and sees if the concatenate string name exist.
If it does exist, then nothing Else create a copy of the template and name it the concatenate string in that cell.

Thank you in advance for any help and please respond with questions if I didn't make something clear enough.

(My apologies I posted in General and not in Excel Programming / VBA / Macros)

[Ajaxs87]

Here is the vba I kind of have in mind, but I guess I need to loop it and I am not sure exactly have loops. Any feedback would be appreciated. Thank you for either reading or helping.

Sub GetFileNames()
Dim FileName As String
Set soms = ThisWorkbook.Worksheets("sheet1").Range("a12")

FileName = Dir("C:\" & soms & ".xlsx")

If FileName = "" Then

FileCopy "C:\Signal App Reporting Template.xlsx", "C:\" & soms & ".xlsx"

Else


MsgBox "File exist"



End If

End Sub

[Ajaxs87]

I figured it out.

I redid my setup for the page so its easier to edit for me down the road. So the VBA code below is related to the attachment to this post.

Sub Loopy()

For i = 2 To 3


FileName = Dir(Cells(i, 5))




If FileName = "" Then

FileCopy Cells(i, 3), Cells(i, 5)

Else
MsgBox Cells(i, 5) & "Already Exist"


End If

Next i


End Sub