Cant click, Auinfo doesnt show Class/Instance

[Bosco]

Hi Guys,

im trying to click inside this:

So I'm trying to get the Data with Auinfo like Class and Instance to use control click.

And when im using Auinfo, this happens:

It selects the whole window.

Its a Windows /Excel window.

Any way around this?

Edited July 8, 2020 by Bosco

[seadoggie01]

What's the big picture thing that you're trying to automate in Excel? Usually it's better to use the object model code to get things done. This looks like you're importing data from another source.

Control Click doesn't usually work if the Au3Info window doesn't show anything.

[Bosco]

Its an Addin to merge different cells. Cause i have to do this for more then 200 worksheets every month, i want to automate the steps. But to use the addin, i have to select the things..

Edited July 8, 2020 by Bosco

[seadoggie01]

All the addin does is merge cells, or are they specific ones? You might be better off rewriting the addin's steps...

#include <Excel.au3>

Local $oExcel = _Excel_Open()
Local $oBook = _Excel_BookOpen("Path\To\Workbook.xlsx")
Local $oSheet = $oBook.Sheets(1)
$oSheet.Range("A1:B1").Merge

How does the addin work?

[Bosco]

Its this Addin:

https://www.ablebits.com/excel-suite/index-2020.php?visitfrom=Spring20-Offer-0

i cant rewrite this  

It checks duplicated rows, combines them and deletes duplicates. Calculates things and so on in 1 Step!

[seadoggie01]

Okay, you're going to need to look into one of two things then: UIAutomation or calling their internal functions (likely written in C#) with your own data. I would suggest UIAutomation, because I doubt they'll allow you to extend their Addin by calling the functions directly.

Basically, AutoIt can't find every single control with ControlClick and other related functions. These functions allow you to find every control that you can see.

[Bosco]

Thx! This helps me a lot!