Izebize Posted November 30, 2007 Share Posted November 30, 2007 I have an excel sheet, with 255 IPs from A1 to A255. I wrote a script to search my actual IP: #include <ExcelCOM_UDF.au3> $oExcel = _ExcelBookOpen("C:\Work\iplist.xls") _ExcelBookSaveAs($oExcel, "C:\Work\Temp\temp.xls", "xls", 0, 1) _ExcelFindInRange($oExcel, @IPAddress3, "A1:A255") _ExcelBookClose($oExcel) It does run, and find my row, but it stops with an error: Line 1131 (File "C:\Program Files\AutoIt3\Include\ExcelCOM_UDF.au3"): $aFound[$xx][2] = Number($Temp1[2]) $aFound[$xx][2] = Number(^ERROR Error: Array variable has incorrect number of subscript or subscript dimension range exceeded. Any idea how can i make it work? Link to comment Share on other sites More sharing options...
PsaltyDS Posted November 30, 2007 Share Posted November 30, 2007 I have an excel sheet, with 255 IPs from A1 to A255. I wrote a script to search my actual IP: #include <ExcelCOM_UDF.au3> $oExcel = _ExcelBookOpen("C:\Work\iplist.xls") _ExcelBookSaveAs($oExcel, "C:\Work\Temp\temp.xls", "xls", 0, 1) _ExcelFindInRange($oExcel, @IPAddress3, "A1:A255") _ExcelBookClose($oExcel)oÝ÷ Ø]¡ë+ºv§uø§vl«£î¶+l¶lÂ+ajw«®À(y¨hÁƧf¤z+p¢¹?ªê-xv«vÚy» Â+a¶¦ÊË^¯'Zµ«µ8b³ +Çâ殶sb6æ6ÇVFRfÇC¶'&æS2fwC°¢6æ6ÇVFRfÇC´W6VÄ4ôÕõTDbæS2fwC° ¢b33c¶ôW6VÂÒôW6VÄ&öö´æWr¤f÷"b33c¶âÒFò# ôW6VÅw&FT6VÆÂb33c¶ôW6VÂÂb33c¶â¢²fײgV÷C²ã"ã2ãBgV÷C²Âb33c¶â¤æW@¢b33c¶e&W7VÇBÒôW6VÄfæDå&ævRb33c¶ôW6VÂÂgV÷C³ã"ã2ãBgV÷C²ÂgV÷C´¤#SRgV÷C²¤b4'&b33c¶e&W7VÇBFVà ô'&F7Æb33c¶e&W7VÇBÂgV÷C´FV'Vs¢b33c¶e&W7VÇBgV÷C²¤VÇ6P ×6t&÷bÂgV÷C´W'&÷"gV÷C²ÂgV÷C´gVæ7FöâFBæ÷B&WGW&ââ'&âgV÷C²¤VæD`¥ôW6VÄ&öö´6Æ÷6Rb33c¶ôW6V Mod this demo with your data to make it fail, so we have something to work with. Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law 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