Add a module in the VBA editor, then add a routine

Sub Auto_Open()
'your code here
End Sub

Robin Hammond
www.enhanceddatasystems.com

"syale" wrote in message
om...
Is there a function that will autostart a routine automatically when
the spreadsheet is opened.

I want to use Windows scheduler to open a spreadsheet which will
gather some information, transform it an dcopy a csv file to another
location.

Stephen