Automatically Save a CSV File

[canam]

I have a csv file that is being used to collect serial data from a wedge program. The file must be a csv. I would like to save the file automatically every 10 minutes to c:\data.csv using VBA but since I am not able to save code within the file I am not sure if this is possible or where to begin. Any help is greatly appreciated.

 

[gelsner99]

I want to save an Excel Worksheet as a CSV file using VBA. And the code I have, will do that, but it also closes the main Excel Workbook. How do I keep it from closing my Workbook. Here's the code: Sub SaveCSVnotExit(sFileName)
Application.DisplayAlerts = False
'---> Save Current workbook just in case latest additions not saved
' ActiveWorkbook.Save
'---> Now create a CSV of the active sheet
ActiveWorkbook.SaveAs Filename:=sFileName, FileFormat:=xlCSV
Application.DisplayAlerts = True
ActiveWorkbook.Close False
'Application.Quit
' Wind up here
Sheets("MyCSV").Select
End Sub