Save and close newly created CSV workbook

Originally Posted by cubangt

put it between your save lines here:

        'Save in CSV
        Application.DisplayAlerts = False
               ActiveWorkbook.SaveAs Filename:= _ 
               (strP & "\YOURFILENAME.csv") _ 
               , FileFormat:=xlCSV, CreateBackup:=False
        Application.DisplayAlerts = True

Perfect! Ill test it out later and get back to you!


Cheers