Excel Loop Speed - (Moved)

[SlackerAl]

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

 

[Lights_On]

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.