General discussion

Hi!
I have some questions:
1) Is there a way to open all files from a folder? -> and put the different names (addresses) to an array?For example, now I ask the user using Input to say the address from the file, but I would like to process a lot of different .xlsx files at the same time.
2) If the user write the address as folder1/folder2/open.xlsx 
Is there a way to break the string and get only the "open"?
 
Thank you!!

hi Brian
I have a program that creates some databases and delete them while the script is running, the script loops few hundred times until it finishes.
somewhere along the execution path the script crashes, in different places, with Idea internal error message. The reason I think it is resources not freed correctly issue is because when I restart the PC I can progress from a saved point to the next crash and so on until the script reaches not so safely the promised land.
 

Hi everyone,
 
I'm new on IDEA and I'm doing my first scripts.
I would like to convert a string into a number format as for example "102.23", I found the function @Val but this one only works on the first figures: @Val(102.23) returns 102.
I could combine this function with the function Split to work arround the coma, but it should exist a simpler method, and I can't find it.
Which funtion should I use?
 
Thank you very much for your help
 
Mac

Hi! Can you help me!?
I'm learning how to do some scripts, but really (really) new to it.
I'm currently trying to create a script that uses the same file to do different things.
Now I'm oppening the file a lot of times to get it's different sheets.
Is that possible to create a function to open the file, and then get those different sheets? Probably passing the address of the file as a parameter.
</code>
Sub Main
Call OpenFile()
Call ExcelImport_sheet1()
Call ExcelImport_sheet2()
Function OpenFile

Hello!
Is it possible to create a script that calls another script?For example, inside a Dialog made with IDEA script langauge i have a button.If i press that button, another script, made in Python will be called to do something.
Is that possible? How can I do that?
Thank you!

I am working on putting more controls in place to check for user input errors when I am building dialog boxes that require user interaction. 
Right now I have a listing of checkboxes to allow the user to select which tests they would like to run.  Out of the five items I have, there are two that cannot both be selected.

Greeting fellow IDEAScripters!
Does anyone have a list of keywords that they use to search for Meals and Entertainment for their comany's T&E program. I am currently looking to try and gather some data on our Customer Meals and Entertainment. Thanks in advance!

Good afternoon,
I am trying to add leading zeros to a character field and want all values in the field to have a character length of 9.  For example, I would like 1234B11 to be 001234B11.  Is there any easy way to do this within the Equation Editor window?
 
Thanks!

Hello everyone, if you have been wondering why I am not around as much as I have used to be it is because I have changed jobs.  After 30+ years with the government of Canada I have retired and joined CaseWare IDEA as an Industry Strategist (Solutions Lead) on their Industry Team.  This will be a great challenge but after five weeks with the company I am loving it.  Because of this change I no longer have time to keep up with the boards on a constant basis, also I no longer have the time to create special scripts for people.  If you have suggestion

While using the function Mid(currentLSD, 5, 2) I am getting stackoverflow error .