General discussion

Is there any way to crate a list of databases name and count the no. of records in each database of a folder?

I have an excel file with more than 20 sheets and the header row is the fifth row. Is there any way to import multiple sheets of a single excel file? Also, can we consider 5th row as my header row?

    Set db = Client.OpenDatabase("Working\Management Fees Final.IMD")
    Set task = db.TableManagement
    Set field = db.TableDef.NewField
    field.Name = "FIRST_DDN_MGMT_FEE"
    field.Description = "Added field"
    field.Type = WI_VIRT_NUM
    field.Equation = "-FIRST_DDN_AMOUNT*COL2*FIRST_DDN_DURATION/365"
    field.Decimals = 2
    task.AppendField field
    task.PerformTask

Hi Brian
 
I hope you are doing well.
I have question for you. I would like to create a drop down list for lots of folders in a folder (these folders are not in the project folder or directory).
Suppse we have a folder in our computer and in that folder we have 35 folders. So these 35 folder should be in the drop down list in the dialog box (instead of writing the folders name in my dialog box, I would like to pick the name from the list)
Is it possible to do that?
I have attached the dialog box I created
 

which function can do the same thing as seekv, I have two databases and I want to lookup a value in one and return it in the other. tks

Hi Brian,
 
I have a question for you. I was wondering if we could use the Thousand separators while we type in the edit boxes?
I mean when we type 12000000, it automatically turns to 12,000,000.
 
Thanks,
 
 

Hi Brian
Thanks for your all supports.
I defined a couple of variables for my dialog box but I receive an error for importing XML file. I think I need to define one more thing in the function.
Would you please run my macros and see how to solve the problem. Thanks :)
 

Hello everyone,
Someone has a scripts that allows me to connect to a page and download an excel document and the same script allows me to save it in a directory, and then export it to IDEA, or has a method to download file from the web

Hi, I have two small doubts that I would like to know if you could help me.
1. I was told that IDEA allows you to schedule scripts to start and run, how do you do that?
2. The second question is how to post code here? I saw that Brian posts the complete code and it is well organized in the forum. I tried to put code between ```, but it does not work.

Hi Brian,
 
Finally I have created my first pro dialog box in IDEA and that's amazing for my future projects.
I wanted to add benford law into the macros (dialog box) but i have got an error: Object variable or With block variable not set!
Please have a look at the attached pic.
Also, some tables may have less than 1000 puplulation so I will receive an error if the number of records is less than 1000 for creating suspicious.
That would be great if you let me know how to script the number of records e.g.