Sorry for the noob question, I just want some pointers on what I need to learn to be able to achieve such tasks.
I want to know what skill-set and tools I will need to automate control any particular software. My goal is to simplify tasks which is similar to creating a micro.
However, I understand a lot of macro programs uses screen x and y coordinates, but I believe a better method would be reading memories with the help such as cheat engine perhaps? is that the tool which I will need? or there is alternative which suites the tasks better?
basically I want let say, a C# winform perhaps, with certain buttons which will help me execute a series of commands. It would be similar to a game bot program but not made for games, but for other office related tasks. such as open files, basic editing and close.
for example:
open excel open file xyz read cell B4 value(perhaps I can use that value elsewhere and display it on the winform or even grab and do some further calculation in C# and throw it back into excel) move to F1 and enter value 1234 save file exit excel
I'm basically looking for a way to make a macro any program not just excel, but without the downside of using x and y coordinates because if program window moves by any chance, it would cause the macro to malfunction.
Therefore, is reading memory of the program consider the best solution? So I can interact with files, data, and commands for any program with the intention to do some desktop usage automation.