Skip to main content

IDEAScript Questions

Dialog Box instead of array

Hi Brian,
I am evolving some of my scripts for better usage and I come up with something I am not sure I can do, therefore I am checking with you. I have this part of code, and instead of an array, I would like to insert a dialog box with check boxes as my audit period will expand from location to location and therefore the last 6 months will be always different. Do you know if it is possible? If so, would you mind providing me some guidance?
Thanks,
Giorgia

Delete an original data field

Hi Brian,
I tried to generate some code by means of the makro recorder in IDEA which allows to delete an original data field. But I did not work. I am searching for a command which turns off the default setting which blocks the delete of original data fields and then turns it on again.
Thank you very much in advance for your help.
Best
Bobby

Import Multiple Excel files and convert to IMD files

Hi there,
I require a script that could perform the following tasks:
- special purpose function that could read and import mutiple Excel files in a folder or directory,
- appends all the Excel files and return a single IMD file, the files are stored in an array,
- display the appended single IMD file into a pivot table.

Large and Unusual extraction

Hi Brian,
I am trying to develop a script to run a 'Large & Unusual' style extraction over a range of different databases. This requires two seperate functions being:

  • direct extraction based on a user defined $value (similar to your IDEA Scripting Tutorial video); and
  • direct extraction based on key words in a character field (such as a description field).

My issue is that our standard databases include:

Script - front end

Hi Brian,
I would like to build a script front end, as I have created a major script with lots of minor script each referring to a specific audit testing, where before runnig everything the user is requested to select some or all analysis to perform and also in which order. Have you ever created something like this? In case, would you like to share with me some guidance or advice? I have never created one. 
Thanks, Giorgia

Set a field as variant in an equation

Hi,
I am trying to automate some analysis and I don't know how to fix the following code in order to include the field as variant because I have several fields in where I need to adjust the format. Can someone help me to insert the variable field in my equation editor? This is where my code stop working, I have copied it here! Thanks
Function ModifyAllDateField (DateField, WorkingDatabase) As Variant

Call script with more 4 parameters

Hi all,
 
I have a problem with my Ideascript macros. I have a macro with different variables and object variables. So I want to send more than 4 variables to other macro but I can't. 
I see and read different solutions such as read variables from a text file (after writing) but I want to avoid use this solution...
Moreover, I didn't find a solution to send an object variable to an other Macro or may be it is not possible...
 
Thanks
 

Script for On Error Resume Next in IDEA

Hi All,
Someone help me please, I want to join database A (Primary) and database B (Secondary) with "All Records in Primary File". My trouble is when in database B there is no records (this is cause depend on automatic script before) then the macro is stop.
May anyone can help me? is there any script like in excel (On Error Resume Next) to join those databases?
thank you