General discussion

I want to thank you Brian and others who helped me with setting up and running a script automatically.  I got upgraded to version 11 and so far am just using Task Scheduler to run the script I needed.  It runs like a Ferrari and is saving me about a days worth of work so THANK YOU so much!

Hello @ all,
first of all many thanks to this forum. Here you will always find inspiration for new projects and competent help and advice!
 
I don't know if someone can help me with my current problem.
In my work I regularly use IDEA10. In this context I have made a suggestion for an extensive macro to make certain processes more efficient. On the part of my German employer I was informed that a corresponding macro would not save any time. I spare myself a comment on this.

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!