Hi all,

I have the below code, and i am looking to take data out of the excel sheet and save it as an external csv, the next time the vb runs, it will just update the same csv. Not sure how far i am but below is what i have:

Sub testexport()
'
' export Macro

Range("A3:A5").Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\gbhwad\Documents\Book2.csv" _
, FileFormat:=xlCSV, CreateBackup:=False
Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True

End Sub

Any help would really be appreciated.