Click/Select Cell in Excel

[232showtime]

Good day,

just wondering if there is another way to click or select on a certain cell??

I tried to use Controlclick it always click on ranged O21

#include <MsgBoxConstants.au3>
#include <Excel.au3>

 

 

Local $oAppl = _Excel_Open()
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookOpen Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

_Excel_BookNew($oAppl, 1)
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookNew Example 1", "Error creating new workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookNew Example 1", "Workbook has been created successfully with only 1 worksheets.")
$_iExcel = WinGetTitle("[CLASS:XLMAIN]")

If $_iExcel Then _iData()

WinMove("[CLASS:XLMAIN]", "", 0,0, 1920, 1080)

Func _iData()
    ControlClick($_iExcel, "", "[CLASS:EXCEL7; INSTANCE:1]")
    MsgBox(64, "", "You Clicked on Random Ranged: O21")
EndFunc   ;==>_iData

 

Where is the autoit code tag??? Its not showing in my browser...

 

 

Edited May 23, 2015 by 232showtime

[water]

Why do you want to mix COM and GUI automation?

[water]

BTW: The AutoIt code tag ist the "<>" button in the editor.

[232showtime]

@water I just want to click Range B14 before I start my Script.

dont have any idea at all that im mixing COM and GUI, all im trying to do is to automate click or select range B14, but still cant figure it out.

I can see Autoit code Tag before, now option is missing, kindly check attachment. is it just me???

 

Edited May 24, 2015 by 232showtime

[water]

To select a range I would use the following code:

Local $oAppl = _Excel_Open()
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookOpen Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

$oWorkBook = _Excel_BookNew($oAppl, 1)
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookNew Example 1", "Error creating new workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookNew Example 1", "Workbook has been created successfully with only 1 worksheets.")

$oWorkBook.ActiveSheet.Range("B14").Select

 

[water]

I can see Autoit code Tag before, now option is missing, kindly check attachment. is it just me???

Might be a problem with the new forum software. Does cleaning the Browser Cache help?

Edited May 24, 2015 by water

[232showtime]

$oWorkBook.ActiveSheet.Range("B14").Select

 

​wow it worked... thanks problem solved...

 

but for the browser,

I cleared the cache for mozilla and i.e. still cant see the autoit code tag option...

 

Edited May 24, 2015 by 232showtime

[water]

Not only the code button is missing ... I suggest to post on the New Forum: Issues and Feedback thread