I have an XLS File sitting on a workstation, the spreadsheet is always open, and is autorefreshing every few minutes and pulling data out of Sage MAS 200 ERP via a query using an ODBC Connection

I need to pass this data to another program every few minutes, and the other program only accepts CSV Files.

So all i need really is a script that will take my XLS File and do a Save as CSV with same file name in same location on a timer.

I see that Excel has an autorecovery type save feature, but no more auto save that overwrites the old copy, which is what i need.

Thanks in advance for help.

I just found another post that answered my question. I now have the spreadsheet autosaving every 4 minutes and overwriting the existing file. Couldnt be happier. I dont know much code, but I sure do love it when a project like this comes together.

Module1:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnTime dTime, "AutoSaveAs", , False
End Sub

Private Sub Workbook_Open()
dTime = Time + TimeValue("00:04:00")
Application.OnTime dTime, "AutoSaveAs"
End Sub


Module 2
Sub AutoSaveAs()
dTime = Time + TimeValue("00:04:00")
With Application
.OnTime dTime, "AutoSaveAs"
.EnableEvents = False
.DisplayAlerts = False
ThisWorkbook.SaveAs "C:\yourdirectory\filename"
.EnableEvents = True
End With
End Sub

Microsoft Excel Password recovery tool is the best solution that given you instant recovery excel password and open excel password correctly. It can allow you to crack excel file password and recover ms excel password with all version of ms excel file. Solution smart for removing excel file password without any harm
Read More:
http://www.excelfilepasswordrecovery.com