General discussion
Dialog Box - Import files _ You must enter a valid file name
Forums
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
Forums
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
Forums
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.
- Read more about Auto starting script and code posting
- 3 comments
- Log in or register to post comments
Error: Object variable or With block variable not set
Forums
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
Forums
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-…
- Read more about CROSSTAB Function
- 4 comments
- Log in or register to post comments
Return time portion from datetime
Forums
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,
- Read more about Return time portion from datetime
- 3 comments
- Log in or register to post comments
Creating a project inside another project
Forums
Hi everyone,
I wanted to know if we can create a project inside another project?
Thanks,
- Read more about Creating a project inside another project
- 2 comments
- Log in or register to post comments
Search Problem (Fields to look in box)
Forums
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,
- Read more about Search Problem (Fields to look in box)
- 6 comments
- Log in or register to post comments
Error Help
Forums
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:
- Read more about Error Help
- 1 comment
- Log in or register to post comments
Exporting two or more tables into different sheets in a single xlsx file.
Forums
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,