![]() |
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 |
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