General discussion

Hi Brian
I have a question for youPlease have a look at the screen shot I attached. I need to pull employees who have the same department and position in the whole table.For instance, Employee ID = 2 has the same department (c) and the same position (Admin) but employee ID = 1 changed the department and position. Also Employee ID = 3 is in the same department but changed the position. I am looking for such an Employee ID = 2
I do not know how to use criterias for such a probelm or write scripts
Thanks

the macro downloads the file in Excel but when going to the ExcelImport routine it throws an error that says "initial load error", what is wrong with this routine? If the file downloads fine. Thanks 
remove the http: so that the address does not stand out
Sub MainIgnoreWarning(true)
Call DownloadFile("//cdn.bancentral.gov.do/documents/estadisticas/mercado-cambiario/documents/TASA_DOLAR_REFERENCIA_MC.xlsx" , client.workingdirectory & "\Archivos fuente.ILB\"  & "TASA_DOLAR_REFERENCIA_MC.xlsx") 

Hello,
How to control if an extraction is empty, which macro continues to export and does not give me a stop. o Idea does not export empty tables?

Hello,
I recently finished a menu that invokes various macros or scripts, and created the project that is going to contain that menu, set it up in the IDEA ribbon.
the question is:
where do the macros or scripts reside do they have to be projects too?
What are the best practices for this menu to work and not give me an error?
have the programs in the menu project in the library macros.ILB ?
Thanks it's my first application in IDEA Scritps

Hello.
Does anyone recommend me a book on script programming in IDEA with VB?

Hello everyone,
I am making a menu which has several cases, in each case I have to do the date conversion routine, what I need is to create a function where I return the values in the desired format, so as not to have to repeat the codes of conversion of the date in each case.
Thank you
Example. 
Case 0  

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