OnTime event to automate my excel sheet

[AndrewLD]

Hi,

I'm stuck working out how to automate my excel sheet i have got.

It has code which when you click the "Save" button it saves the document and then converts a copy as CSV with the same name.

I have been trying to automate this to run every 2 minutes but everything i have tried does not work.

I have tried using OnTime events but again does not work.

Could someone point me in the right direction or help me with automating this workbook?

Thanks in advance.

Andrew

[AndrewLD]

No one have any experience with ontime / scheduling events?

[Andy Pope]

Details of OnTime.
http://www.cpearson.com/Excel/OnTime.aspx

I would move the code in the BeforeSave event into a separate routine in a standard code module so that you can call it using the OnTime method.