use inputbox to open excel file please help Topic is solved

[adrian_9382]

hi all , i am a beginning student .
i design a script to get xls value to search but existing path is fixed , i hope use inputbox to input xls path and always select the excel sheets1 for start page to get value


what can i do ................ please help ............




filepath:=A_ScriptDir "\"
InputBox,_filepath,Open excel file！,please input xls path ,,300,200,,,,15,%filepath%

objExcel := ComObjCreate("Excel.Application")
;objWorkbook := ("C:\Users\adrian\Desktop\test.xls")
objWorkbook := objExcel.Workbooks.Open, %filepath% ;*************don't working

X=1
loop
{
strCell := objExcel.Cells(X, 1).Value
MsgBox, % strCell

;run notepad
;click 287,880
;sleep,1000
;click 436,156
;send, ^a
;send, {delete}
;Send, % strCell
;send, {enter}
;sleep,6000

;;;;do-something;;;;;;

x:=x+1
if (strcell =""){
return
}
}


return
exitapp

[Blackholyman]

how about

Code: Select all

FileSelectFile, filepath
objExcel := ComObjCreate("Excel.Application")
;objWorkbook := ("C:\Users\adrian\Desktop\test.xls")
objWorkbook := objExcel.Workbooks.Open(filepath)

?

[adrian_9382]

omg ! thank you this amazing ! but i have a question . if i use fied path to open xls the msgbox show value is 126 why use fileselectfile show value is 126.000000
how can show interger