It's been a long time since I have been here and have got a little (A lot!) rusty ;)
I have been tasked at work to come up with a solution to track peoples time on projects. I am creating a proof of concept and need it to do the following:
Read/write to Excel which I have read is possible with ADO
Know if the Excel file is open and highlight it unable to write to the Excel
Open up application in the morning, Store locally selected information and update when application is shutdown at the end of the day
If all of the above is possible then thats great I'll crack on! if not then back to the drawingboard.
If any of you know of any examples or functions which might help me learn a little quicker, then please do not hesitate to post them here ;)
Welcome back :)
1. Check out ADO.setConnectString. There are links to Microsoft pages detailing the required connection strings.
2. ssCore.SysInfo.getWndowList may help you find out if a specific Excel file is open.
3. ssCore.FileSys.writeToFile and appendToFile will enable you to write data locally, readFile enables you to read it back, so from there you can do what you need with the data during the day. You can use ssCore.App.setNotify to listen for when the user tries to close your application. When you get that notification, you can then do whatever you need with your data, and then force the application to close with forceQuit.
Thats great and so quick!