i Team,
I would like to get a macro code for the below activity.
I have bank statement in CSV format, my macro code code should read the close csv and get relevant data and create another csv and paste it there.
I have a database of account , account number and manageent company hence the code should only copy details for matching account from closed CSV .
Can someone please help me.
Dim fn As String
fn = "_" & Format(Now, "yyyymmddhhmmss")
ThisWorkbook.Worksheets("Data").Copy
With ActiveWorkbook
Application.DisplayAlerts = False
.SaveAs Filename:="C:\TMU-Export\TMU_Sales" & fn, FileFormat:=xlCSVUTF8
Application.DisplayAlerts = True
.Close savechanges:=False
End With
End Sub