Automating the export to csv function

Hi All,

Is it possible to run somesort of VBA code that exports a whole sheet into a csv format on opening, closing & every 15-20min. I can do the opening closing bit but not the the timed section.

All it would be is to export say Sheet named Data into a predetermined file name and location within the code

Thanks in advance

Danny

Have a look here for a very similar question with an answer.

http://stackoverflow.com/questions/2...-i-e-120-secon