Recently Browsing 0 members
No registered users viewing this page.
I face an Excel related error right after doing an _Excel_BookOpen. This is an EXCEL worksheet with filters defined, quite simple sheet. Once a week at Friday there is a scheduled task running on the file server "printing" the content to a PDF file for documentation puposes. As this is running 100% unattended it's a show stopper, if such dialog boxes show up.
Already when I did that script a month ago I faced the issue, that to dialog boxes showed up telling something about a "name conflict", once for "_FilterDatabase", and a 2nd time for "PrintingArea" (maybe _PrintingArea).
When some new name is entered, the script is going on with the PDF creation. But the autoit script is hanging with the _Excel_BookOpen, so I would need to start a 2nd. script to look for such bogus name conflict message boxes.
While trying do track down what's going on in detail, the issue vanished again, I answerd the two boxes with "xxxx" and "yyyy" for new fiel names, the file seems to have been saved by me myself without intention (or automatically by EXCEL.AU3?)
several other postings point into the direction of "this is an Excel Bug", seems to be not strictly Autoit related.
Windows 7 Pro x64 Office 2010 SP2 32bit Localization = German (Win & Office) Autoit v126.96.36.199 Excel Workbook with three sheets without any Macros: "TBx Projektliste.xlsx", just 82 kByte
Any suggestions howto take care, that these "name conflicts" cannot occure?
[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)