Thanks Dick. Yes, that works. I had already used that method as a workaround. I am just trying to see if it is possible to do use the array variable directly in a complex expression. The way the array was loaded is let>crit[1]=IP_Criteria Thanks for the reply, JWM quote="JRL"]Try setting the array v...

I have a script in which I have an array setup that stores range names from an Excel spreadsheet. The array is crit. When I call the array variable from a complex expression I get error messages. I have tried every combination of % signs around the variables I can think of and I still get an error. ...

Thanks for the quick response it works great. I was following the example in MS Help for non-modal dialogs. I thought I had to re-assign dialog variables to diaog to reflect the users selection on each iteration of the loop.

Does resetDialog only reset the dialog result to zero?

JWM

I have set up a script file (see below) to retrieve two files and allow the user to determine the period in years over which to execute the script. When I click the "Get Finance Extract File" button or the "Get CWIP Diffs File" button they will not always retrieve the file selected. It may take 3 - ...

Do you have an example of how to use the FileBrowse object in the new MS version 7.3.10?

I get the same result. The window that comes up shows the message "true". I tried adding CloseWindow>Macro* as next command, but the "true" message comes up before that line of script is executed. Bob, That cleared up the problem for me in both the test script I posted and the application script. T...

The following script causes a modal dialog box, with the title Macro..., to pop up when the script executes the setenvvar command. The user must click the OK button in the dialog box before processing continues. How do I keep the dialog box from appearing each time setenvvar is executed? I've includ...