Skip to main content

General discussion

Dialog Box - Import files _ You must enter a valid file name

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 :)
 

scripts that allows me to connect to a page or has a method to download file from the web

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

Auto starting script and code posting

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.

Error: Object variable or With block variable not set

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.
 

CROSSTAB Function

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-…
 

Error Help

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:

Exporting two or more tables into different sheets in a single xlsx file.

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,