5 posts in this topic
[SOLVED] _Excel_BookOpen how to connect to already opened Excel Application, without knowing the filepathBy SorryButImaNewbie
Hello dear users!
I have a bit of a problem with my excel script I try to make. My goal is that my script would read through an excelfile's columns and rows, identifiying key words, then I would like to reorganize the rows and colums in the a specified "way", "format" (we get different kind of excels in and i wish to produce a uniform excels from them, the data is the same, so I know that there is an XY column somewhere, I just have to find it, and put it in the right place)
Now I can read values from cells (or range of cells) but only if I know the exact file name and path.
Can I make autoit to somehow attach to the already opened excel? This way I would be able to make the script, so the user just open the excel which he/she wants to format, clicks on go, and viola.
Instead now I'm thinking adding 2 textboxes to my GUI so the user can write down the filename and file path, which isnt that ideal.
My original idea, was to make the script find the "borders" of the filled out excel form, copy it away to the right, delete the original data, reorganize it the way it should be (to the area which it cleared), and thats it. The user can then quickly check if everything is okey, and he/she can delete the copied original data set if its needed.
So in short my problem is, how to connect my script to an excel thats presumaby already opened, without knowing the filename and path?
Thank you for your help! (and sorry if there is already a post about this I havent found it)