Sign in to follow this  
Followers 0
Izebize

Simple Excel Find in Range

2 posts in this topic

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?

Share this post


Link to post
Share on other sites



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.

:P


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

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0