Arclite86 Posted February 6, 2014 Posted February 6, 2014 I am keep getting the same error and i dont know how to deal with it --> IE.au3 T3.0-1 Warning from function _IEAttach, $_IEStatus_NoMatch --> IE.au3 T3.0-1 Warning from function _IEAttach, $_IEStatus_NoMatch "C:\Program Files (x86)\AutoIt3\Include\string.au3" (42) : ==> Subscript used on non-accessible variable.: Func _StringBetween($sString, $sStart, $sEnd, $fCase = False) Func _StringBetween($sString, $sStart, $sEnd, $fCase = Fals^ ERROR ->12:02:48 AutoIt3.exe ended.rc:1 and this one (shutsdown automaticly) "C:\Users\joesoef pc\Desktop\autoit\excel.au3" (14) : ==> Subscript used on non-accessible variable.: ConsoleWrite("Elements: " & $aArray1[0] & @CRLF) ConsoleWrite("Elements: " & $aArray1^ ERROR ->12:03:58 AutoIt3.exe ended.rc:1 +>12:03:58 AutoIt3Wrapper Finished.. (doesn't show results)
FireFox Posted February 6, 2014 Posted February 6, 2014 Hi, Can you post your script please? Br, FireFox.
Arclite86 Posted February 6, 2014 Author Posted February 6, 2014 Hi, Can you post your script please? Br, FireFox. expandcollapse popup#include <Excel.au3> #include <IE.au3> #include <string.au3> Global $excelfile = "C:\Users\joesoef pc\Desktop\autoit\twitter.xlsx" Global $oExcel = _ExcelBookOpen($excelfile) _ExcelWriteCell($oExcel, "username", 1, 1) _ExcelWriteCell($oExcel, "followers", 1, 4) _ExcelWriteCell($oExcel, "following", 1, 8) _ExcelWriteCell($oExcel, "followbacklist3", 3, 1) Global $aArray1 = _ExcelReadArray($oExcel, 3, 1, 7,1) ConsoleWrite("Elements: " & $aArray1[0] & @CRLF) For $i = 0 to UBound($aArray1, 1) - 1 ConsoleWrite("Element: " & $i & @CRLF) ConsoleWrite(" User: " & $aArray1[$i] & @CRLF) ConsoleWrite(" Row: " & $i & @CRLF) _Volgend($aArray1[$i], $i + 3) Next Exit Func _Volgend($sUser, $iRow) $oIE = _IECreate("https://twitter.com/" & $sUser,0,1) if @error then MsgBox(0, "", "gevonden" ) $oInput2s = _IETagNameGetCollection($oIE, "a") if @error then MsgBox(0, "", "gevonden" ) For $oInput2 In $oInput2s If $oInput2.className() = "js-nav" Then If StringInStr($oInput2.innerHTML(), 'Volgend') Then ConsoleWrite(_StringBetween($oInput2.innerHTML(),'>','<')[0] & @CRLF)If @error Then MsgBox(16, "Failure", "failure.") ExitLoop EndIf EndIf Next $numbvolgers = (_StringBetween($oInput2s.innerHTML(),'>','<')[0] & @CRLF) $numbvolgend = (_StringBetween($oInput2.innerHTML(),'>','<')[0] & @CRLF) ConsoleWrite(" Value: " & $numbvolgend & @CRLF) MsgBox(1, "oko","jijij"&$numbvolgend ) _ExcelWriteCell ($oExcel, $numbvolgend, $iRow, 3) EndFunc this is the script if you can get this to work i would be so happy, the number show up in the description but it does not paste it intro excel file my intention is to get the function working for all the names..
water Posted February 6, 2014 Posted February 6, 2014 Arclite86, why do you open another thread for the same issue? /?do=embed' frameborder='0' data-embedContent>> My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Moderators Melba23 Posted February 6, 2014 Moderators Posted February 6, 2014 Arclite86,You seem to be making a habit of this - please stick to just the one thread in future. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now