IDEAScript Questions
Monetary Unit Sampling
Forums
Hello,
I am an advanced beginner with VBA and novice IDEAScript writing.
I am trying to set-up a macro that prompts the user to select their file from a shared network drive and then process a plan and select the sample. I tried to re-work the process by recording a macro and reviewing the script.
Below I have copied the script generated from the macro. The deficiencies compared to what I would like to achieve are:
(1) Display a prompt allowing the user to select any file type via any file path
- Read more about Monetary Unit Sampling
- 1 comment
- Log in or register to post comments
Sort column
Forums
Hi.
I need to search through a column at an IDEA base by a value. In order to easy my work, I would like to sort this column first, the same way when you create an index just by clicking at the header of the column.
My question, is there a way to create an "Index" using ideascripting or any other way to sort the columns's rows?
- Read more about Sort column
- 5 comments
- Log in or register to post comments
Locate Script Path
Forums
Hi Brian,is it possible to find out at which path the script is running, so I can save the value in a variable.Thanks
- Read more about Locate Script Path
- 10 comments
- Log in or register to post comments
update textbox text
Forums
Hello,
I have created an interface with a textbox. I want to refresh the text of this texbox with the "progress status" of the script ( the script execution manage billions data and can last 10 hours).
I try to use the dlgtexbox with no success. I can easyly define the intial content, but not update it whitout action of the user.
It is possible to change the textbox content ?
Thanks (excuse my bad english, i'm french)
- Read more about update textbox text
- 1 comment
- Log in or register to post comments
Capturing data enterred by user
Forums
I have a script requiring the user to enter a run date
I get the following error when running it - "Error on line 26 - type mismatch" (see file upload)
The coding is below - where am I going wrong? (see file upload)
- Read more about Capturing data enterred by user
- 8 comments
- Log in or register to post comments
Deleting an Excel file from an IDEA script
Forums
I'm new to IDEA scripting and wonder if anyone has a script that will delete and external Excel file from an IDEA script?
- Read more about Deleting an Excel file from an IDEA script
- 3 comments
- Log in or register to post comments
Change column position
Forums
Hello, i need help if it is possible.
I have 1 big batabase (like 400 columns and 8mil rows). I need to pick 120 specific columns a array theirs position. Im trying to do this using Extraction with task.AddField function and it work pretty good. But there is a problem i cant solve. When I save this new database using this Extraction and want to do some other activities with it (like new Extraction etc.) all arangement of colums will return to the state of the first big database (according to its history).
- Read more about Change column position
- 3 comments
- Log in or register to post comments
Change Record Number
Forums
Hello,
I have a set of data that has an assigned account number. I would like to select from this data a sample, but I wish to not select more than 5 items with the same account number.
- Read more about Change Record Number
- 2 comments
- Log in or register to post comments
How to hide a field?
Forums
Hi again,
I was looking for method, how to hide a field, but I found only one similar thread on this forum, but without an explanation which commands to use.
Assuming I have a database "db.IMD" and I want to hide field "CHAR1"
Function hide(dbase As String, fieldname As String)
Dim db As database
Set db = client.OpenDatabase(dbase)
.....Something like db.HideField(fieldname)???
End Function
Many Thanks
Anre
- Read more about How to hide a field?
- 6 comments
- Log in or register to post comments