Skip to main content

General discussion

Thank you Brian

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!

cost of IDEA and SDK

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.

Open file - Address inside IDEA Script

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!!

Free Idea Internal Resources

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.
 

Convert text to number

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

Variables as parameters

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

Checking user Inputs for errors

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.