IDEAScript Questions

Hey everyone,I've just got asked to automate IDEA completely that it would require no user interaction and I was wondering whether this is possible at all.

Wondering if anyone has a short function for checking if an Excel file is open? I've found a few VB examples, which don't seem to be compatible within the IDEA Scripting environment.

Hi
Can anyone help me with a function basic or @ that will allow me to subtract a specificed time from a date.
E.g. in basic this would be DateAdd("M", -1,"01/01/2015") would give 01/12/2014 - (thats in english DD/MM/YYYY format) but the dateadd function does seem to exist in IDEA
thanks
 
 

I am working on creating my scripts to audit multiple systems at once. I am currently using Excel to perform this task but Corporate policy is directing me to move to IDEA. I have most of the scripting done but I am wanting to export multiple database files to one Excel file. I know this is possible if I were statified with .XLSX but I need it to be .XLSM. Do you know if this is possible?
Thanks

Hi,
I would like to know if it is possible to create a variable that is very general:
for example "Dim a as an integer" with a=any integer or a range of integer.
I would like to do that because I have some field names whose name are pratically the same, only the number at the end change:
"SEGMENT1"
"SEGMENT12"
"SEGMENT13"
I would to know if it is possible to have a variable that can store any integer and have something like:
"SEGMENT"&a
Thanks in advance for the help :)

Hi,
I have 5 joins to make, I put a picture to show what I mean. I would like to use the client.uniqueFileName for the name of each database after each join.
I manage to use  the client.uniquefileName for the two first join by using the method "calling a sub-routine" but I can not add the 3rd, 4th and 5th join.
I do not manage to pass the filename from the 2nd function to the 3rd function.
I can not upload my scripts, they are in .ism :(
Thanks in advance for the suggestions :)
 

Hi,
I have to hide a column which is used for internal calculations. This column will be created from code and should not be visible to user by default.
I am using TableManagementLib.TableManagement to append field. I don't see any attribute in COMDBLib.Field interface for setting visible property.
Is there any work around for this?
Thanks,
Shafeer
 

Hi Brian
I was trying to perform from an Idea script some manipulations on excel cells. most of the manipulations works fine, but I could not find the equivalent to the folloing VB line:
 ActiveSheet.Range(Selection, Selection.End(xlToRight)).Select
this line select one row of excel cells from the current active cell to the rightmost non empty cell.
Naturally I tried the following, but it yield an error:
Set ex = CreateObject("Excel.Application")

Hi
Can anyone help me understand how to perform a many join?
I.e. a primary record in the resulting table for each record in the secondary table?
This is best explained in the pictures below.
Thanks

I stored field names in a array and tried to pass array as a parameter to a function but Idea threw an error.
sub main
      Dim fieldname(2) as String
      fieldname(0) = "Acct_num"
      fieldname(1) = "Acct_Desc"
      fieldname(2) = "JE_num"
       PrintArray(fieldname)
end sub
Function  PrintArray(Arrayname() as String) 
     for i = 0 to ubound(Arrayname)