To be very precise of my concern that the workbook developed by me can incorporate 7 payment particulars comprising of 8 columns and 7 rows. In a day around 35-40 entries/rows are required to send to our banker. So each time a set of 7 is ready (A4 size paper), it is required to save in a distinct manner to recover the information later when/if required.
To ease this process we include (i)/(ii)/(iii) as required after the file name say RTGS BANK TEMPLATE - (?)
I am including underneath what I have tried.
*Sub SaveAsDialog()
On Error Resume Next
With Application.FileDialog(msoFileDialogSaveAs)
. Title = "Please choose a location and file name to save"
. ButtonName = "SAVE AS"
. InitialFileName = "E\Backup\SWARNALI\RTGS TEMPLATE(PARTY)\" & Range("").Value
If .Show = 0 Then
MsgBox "The file did not save.", vbCritical
Exit Sub
End If
Application.DisplayAlerts = False
. Execute
Application.DisplayAlerts = True
End With
End Sub*