I am trying trying read a value in another excel spread sheet in code that is being written for a cell formula. The best way I have found to read data in closed spreadsheets is using the ExecuteExcel4Macro command. But though some careful testing and research, it seems that ExecuteExcel4Macro cannot be run as code in speedsheet cell formulas. Is there a way to make ExecuteExcel4Macro work inside cell formula code, or is there another way to find out information in other excel spread sheets? See example of what i'm trying to do below.

Cell A1 contains "2"
Cell A2 contains "=test(A1)"

Please Login or Register  to view this content.