How to pass variables between programs without accessing disk?

Question

Windows

In the Excel program, it passes variables to the compiled autoit script and vice versa. Now the transfer is carried out through calls to the database and files with variables on the disk. I want to get away from using physical memory in the direction of operational. I understand that it is possible to use storage in RAM, but I cannot understand the mechanism of interaction of both excel and autoit with the program in the OP. For example, with a VBS proxy script. Through WinAPI, I can start and stop the batch file, but how to make requests to the script? Implement API in it?
Please name the existing solutions for transferring variable values ​​without using disk memory.

Answer 1

on the one hand there are many options, on the other hand

no need to reinvent the wheel

1 - Excel, like all MS Office programs, has a developed OLE Automatin infrastructure, including that available from almost all major scripting tools. request example https://duckduckgo.com/?q=AutoIt+OLE+Automatin&t=f...
2 - if you run an external script from Excel itself, remember that you can always pass some input parameters. let's say to the script the path to the book, the name of the sheet, the address of the cell / range, and so on. then from a script to use OLE Automatin to this book/sheet and td. query example https://duckduckgo.com/?q=AutoIt+%D0%B2%D1%85%D0%B...
ps if necessary, just replace AutoIt queries with VBS, BAT, WSH, PowerShell, C#, VisualBasic and so on
pps

When I wrote my question, I thought about an analogue of scripting.dictionary with the possibility of access from another program: a dictionary hangs in the processes, one program writes to it, another reads it. And it seemed that updating the API to the existing dictionary was a trifling matter.

Excel book as a "dictionary" (or InMemoryDB) with OLE access - the easiest option to learn
, there are many others. but you have to learn how to program. The most popular lightweight database is SQLite. By the way, does InMemory mode have
any problems? create! ))
- https://duckduckgo.com/?q=AutiIt+SLQlite&t=ffab&ia=web
- https://duckduckgo.com/?q=Excel+SLQlite&t=ffab&ia=web