I would like to code month and year and add to FileName = EIGHT (JANUARY 2020)
HOW DO I ADD MONTH AND YEAR FUNCTION.
HERE IS MY FULL CODE
Function FileExist(FileFullPath As String) As Boolean
Dim value As Boolean
value = False
If Dir(FileFullPath) <> "" Then
value = True
End If
FileExist = value
End Function
Private Sub cmd_exportPDF_Click()
Dim fileName As String, fldrPath As String, filePath As String
Dim answer As Integer
fileName = "EIGHT" 'filename for PDF file*
THE FILE NAME IN PDF EXPORTS SHOULD BE UPDATED AUTOMATICALLY TO ( EIGHT JANUARY) without me typing the code manually to JANUARY