SlackerAl Posted May 20, 2019 Share Posted May 20, 2019 I think someone else can probably answer this better than me... I have used sqlite extensively with AutoIt and it works really well (just use the help), but to access it from vba you will need to use ADO, this might help https://stackoverflow.com/questions/42509154/accessing-a-sqlite-database-in-vba-in-excel Or you can do it the other way around if you have access on all of the user machines you can then use ADO to connect to it from AutoIt (I'm sure someone here can help with that). Or you can flat file it (depending on the level of robustness, security, and any file locking issues). Or you could vba the external links if you don't mind having all your passwords stored / visible in a master excel document. A quick search found this https://stackoverflow.com/questions/47068941/linking-to-password-protected-workbook (second answer) https://stackoverflow.com/questions/42067872/how-to-get-data-from-password-protected-and-closed-workbook-with-in-excel-2007 Problem solving step 1: Write a simple, self-contained, running, replicator of your problem. Link to comment Share on other sites More sharing options...
Lights_On Posted May 21, 2019 Author Share Posted May 21, 2019 Hi SlackerAI, This is really appreciated thank you. I shall take some time to read this - I think a broader move in this direction may be best. Thank you all. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now