Guest grzegorzj Report post Posted 11/30/2009 03:00 PM Hello, I would like to compare two numbers from excel file and says it to caller. First VG has to recognize number (by DDI - in my test case 9940) than compare it with excel file and say this numbers. I cannot get evaluate expr. to use it in say module. If this could be one eval there is no problem ([something_1_1]) but there is many items (see log file). I need some help because I think that my paths are wrong (see scenario in attach). Thank You. dynamic.zip 1130vgm.zip Share this post Link to post
SupportTeam Report post Posted 11/30/2009 08:20 PM The script seems to be using $RVs: $RV[old] and $RV[new] without them being defined. Is this what is causing your problems? If you are trying to lookup data based on particular input then we would suggest using a Database (eg: MS Access) instead of Excel. Excel is not a very good data store to use if you are trying to do a data lookup. Even for simple number->number translations as you seem to want to do here. 155055,67 1 rv replace start: [sheet1$C$RV[old]$RV[new]] .. 155056,86 1 state [Zmienna1] Evaluate [$RV[old]] Share this post Link to post
