General discussion
Thank you Brian
Forums
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!
- Read more about Thank you Brian
- 3 comments
- Log in or register to post comments
cost of IDEA and SDK
Forums
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.
- Read more about cost of IDEA and SDK
- 1 comment
- Log in or register to post comments
Open file - Address inside IDEA Script
Forums
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!!
- Read more about Open file - Address inside IDEA Script
- 6 comments
- Log in or register to post comments
Free Idea Internal Resources
Forums
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.
- Read more about Free Idea Internal Resources
- 9 comments
- Log in or register to post comments
Convert text to number
Forums
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
- Read more about Convert text to number
- 1 comment
- Log in or register to post comments
Variables as parameters
Forums
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
- Read more about Variables as parameters
- 2 comments
- Log in or register to post comments
Create a script that calls another script.
Forums
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!
- Read more about Create a script that calls another script.
- 3 comments
- Log in or register to post comments
Checking user Inputs for errors
Forums
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.
- Read more about Checking user Inputs for errors
- 3 comments
- Log in or register to post comments
Keyword List for Meals and Entertainment
Forums
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!
- Read more about Keyword List for Meals and Entertainment
- Log in or register to post comments
Adding Leading Zeros
Forums
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!
- Read more about Adding Leading Zeros
- 4 comments
- Log in or register to post comments