Function workbook_path(txt1 As String) As String
Dim pathname As String
Dim wkb As Workbook
pathname = Environ("Temp") & txt1 & " " & VBA.Format(VBA.Now,
"ddmmmyy_hhmmss") & ".xlsx"
If Sheets("Branch Name").AutoFilterMode = True Then
Sheets("Branch Name").AutoFilterMode =
Dear Mr. Richard,
Thanks for the reply. im really happy for received E Mail from you for what
i'm expected and i have few more requirement to fulfill the process what i
exactly need as mentioned below.
1. I want to send it through MS Outlook instead of Gmail.
2. Not Require a Command Button in Ex
