VBA export data to path dpends upon 1 combobox values sheets & 2 textbox date values

Dear Sir

I have set of user-form contains with Combox & 2 textbox and to generate report one cmd button

I have 3 different sheet contains report of daily activities ( Dispatch,Closed,Cancel)

If Dispatchcalls Select In Combobox1 ,Then Filter Start And End Date In Two Textboxes Then Click Cmd" Export Data To Excel" Extract Data from dispatchcalls Then Save Data Into Excel File As "Dispatchcalls".

If Closedcalls Select In Combobox1 Then Filter Start And End Date In Two Textboxes Then Click Cmd" Export Data To Excel" Extract Data from Closedcalls Save Data Into Excel File As "Closedcalls".

If Cancelcalls Select In Combobox1 Then Filter Start And End Date In Two Textboxes Then Click Cmd" Export Data To Excel" Extract Data from Cancelcalls Save Data Into Excel File As "Cancelcalls".


"C:\Users\mani\Desktop\New folder\Lenvo_Reports\ONSITE Cases\Vlokupuf" This is path i stored existing 3 file dispath,closed,cancel
Thanks in advance

find the attahcment