Jump to content

Cant click, Auinfo doesnt show Class/Instance


Recommended Posts

Hi Guys,

im trying to click inside this:

grafik.png.0044ff82149ab9116b240062ad76bc58.png

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:
grafik.png.d1d88dd0bbe789bcf2975c983a8c2ce2.png

It selects the whole window.

Its a Windows /Excel window.

Any way around this?

Edited by Bosco
Link to post
Share on other sites

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.

All my code provided is Public Domain... but it may not work. ;) Use it, change it, break it, whatever you want.

Spoiler

My Humble Contributions:
Personal Function Documentation - A personal HelpFile for your functions
Acro.au3 UDF - Automating Acrobat Pro
ToDo Finder - Find #ToDo: lines in your scripts

Link to post
Share on other sites

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 by Bosco
Link to post
Share on other sites

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?

All my code provided is Public Domain... but it may not work. ;) Use it, change it, break it, whatever you want.

Spoiler

My Humble Contributions:
Personal Function Documentation - A personal HelpFile for your functions
Acro.au3 UDF - Automating Acrobat Pro
ToDo Finder - Find #ToDo: lines in your scripts

Link to post
Share on other sites

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.

All my code provided is Public Domain... but it may not work. ;) Use it, change it, break it, whatever you want.

Spoiler

My Humble Contributions:
Personal Function Documentation - A personal HelpFile for your functions
Acro.au3 UDF - Automating Acrobat Pro
ToDo Finder - Find #ToDo: lines in your scripts

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...