Use autoit on excel file that is already open.

[mithandir1]

Is it possible to read data from an excel file that is already open as opposed to reopening the .xlsm file  everytime I run the script?  The spreadsheet I am using is very complex and takes a considerable about of time to calculate  Everytime I edit the autoit script I am reopening the file and waitng for it to calculate and it is taking way too much time.  Does anybody have any suggestions?  Thanks.

[water]

You can use the Excel UDF and try function _ExcelBookAttach. But make sure that the user doesn't edit a cell because the script will crash if you try to read this cell.

[mithandir1]

Thanks.  That is exaclty what i was looking for.

[water]

If the functions of this UDF are too slow for you you could try my rewrite of the Excel UDF. It requires the beta version of AutoIt but is much faster than the "old" UDF.