Jump to content

Problem AutoitX using in Excel 2003


steve18503
 Share

Recommended Posts

Hi all,

I am facing a strange problem on using AutoitX.dll (3.2.12.1)

I should run many codes and function from Autoit normally in Excel 2003

When I code as below

$ctrl = ControlGetHandle("Source","","SysListView321")
ControlListView("Source", "", $ctrl, "select all")

$name = ControlListView("Source", "", $ctrl, "finditem", "0 KB",1)
MsgBox(0,"First name",ControlListView("Source","",$ctrl,"GetText",$name, 0))

It runs normally directly compile and run by autoit3

But when I code in Excel with autoitx.dll

Dim cAutoit As New AutoItX3Lib.AutoItX3

Dim infosheet As Worksheet
'Set infosheet = ThisWorksheets.Sheets("Sheet1")

Dim ctrl
Dim data

cAutoit.WinActivate ("Source")
cAutoit.WinWaitActive ("Source")
ctrl = cAutoit.ControlGetHandle("Source", "", "SysListView321")
data = cAutoit.ControlListView("Source", "", ctrl, "FindItem", "3 KB", 1)

MsgBox 0, vbInformation, "Checking", "", data

It seems the data always return "0"

The row of the item "3 KB" should be at row 7, but the function still return a value "0".

And I try to Finditem which not exist in the list, it still return "0". (which should be return -1)

Can anyone help me or anyone face the same problem so we can dicuss it here?

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...