ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Autostart (https://www.excelbanter.com/excel-programming/289514-autostart.html)

syale

Autostart
 
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

Robin Hammond[_2_]

Autostart
 
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





All times are GMT +1. The time now is 02:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com