You might be able to do it through the CreateObject or GetObject functions but I wouldn't recommend it. One problem is you would be calling IDEA from within IDEA and I am not sure how that would be handled and also using the RunIDEAScriptRV would be calling your script for each row as the custom function works row by row. So if you have a 100,000 record file you would be calling the ideascript 100,000 times, this would be extremely slow. It would be better to incorporate your script directly in the Custom Function so that it will work as efficiently as possible.
Hi Nils,
Hi Nils,
You might be able to do it through the CreateObject or GetObject functions but I wouldn't recommend it. One problem is you would be calling IDEA from within IDEA and I am not sure how that would be handled and also using the RunIDEAScriptRV would be calling your script for each row as the custom function works row by row. So if you have a 100,000 record file you would be calling the ideascript 100,000 times, this would be extremely slow. It would be better to incorporate your script directly in the Custom Function so that it will work as efficiently as possible.
Brian