General discussion

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.
 

Hi everyone,
 
Do we have "CROSSTAB" function in IDEA? I know we can make it via pivot table but the problem is IDEA does not create macro for a pivot table!
I am looking for this function to make it manually and then save it into a macro for future work.
The link below is a description for crosstab query:
https://support.microsoft.com/en-us/office/make-summary-data-easier-to-…
 

Hi everyone,
 
I am wondering if there is a way to return the time portion from a datetime character value?
I tried @Ctot function but it returns "00:00:00".
I mean it should pull "01:28:31" from "12-Apr-2021 01:28:31". I am looking for a function not macros scripts.
 
Thanks,
 

Hi everyone,
I wanted to know if we can create a project inside another project?
 
Thanks,

Hi everyone.
I cannot select the fields I want to search. All the fields are character and I type text in the "text to find" box!
Thanks,

I'm adding errorhandlers to a series of pre-existing scripts.  These scripts are for analysts with a wide variety of technical ability to use so I'm trying to keep them simple.  One thing I've been unable to find is a list of the properties IDEA makes available for an error object (.number, .description, .WhatElse?).  The two scenarios where I need more information than I have are as follows:

Hi everyone,
I wanted to know if there is any way to export my tables as Excel format (each should be in a separate sheet) into a single Excel file. Tables a, b, and c should be exported as different sheets into an Excel file named "X".
 
Thanks,