Arclite86 Posted February 6, 2014 Share 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) Link to comment Share on other sites More sharing options...
FireFox Posted February 6, 2014 Share Posted February 6, 2014 Hi, Can you post your script please? Br, FireFox. Link to comment Share on other sites More sharing options...
Arclite86 Posted February 6, 2014 Author Share 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.. Link to comment Share on other sites More sharing options...
water Posted February 6, 2014 Share 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted February 6, 2014 Moderators Share 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 Link to comment Share on other sites More sharing options...
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