IDEAScript Questions

I am new to scripting and have a few questions:
1. If I create a script based on a specific file and later want to run that script on another file, how do I do it without having to go into the script and modify the file? Is there a way to create a script not based on a specific file but just the open file in IDEA?
2. I have criteria to enter into a script but have been told it isn't possible. Is it possible to enter criteria/formula into the script?
Thanks for your help.

When importing an Excel spreadsheet using in V9 is there anyway of not assigning the sheet name (first sheet always being imported from the spreadsheet) to the imported database name i.e. spreadsheet name= Prefix, sheet name= x. Normal database name imported =Prefix-x but would just like to have the database output to be named as Prefix. 

Dear Brian,
apologies for the subject  but it is Friday. I was wondering if you have any tips or a script on how to run median absolute deviation (MAD). I refer to chapter 6 of Nigrini's book and I find the MAD concept quite interesting. I have tried to use  the formula using normal functions but it gets messy. Any tips?
cheers
 
Stefano 

Hi,
I am creating a new ribbon under Smart Analyzer. Please see the image.  I am unable to set image for the 'Banking Procedures' like that for Data Request, Tagging etc. Please advice.
Thanks,
Shafeer

Hello,
I'm new here and looking for an easy wildcard (hopefully the right term in English) in the database-name.
At the ? below It's not working with % or * or $ of "?" and I want to make one script for all years.
 
Part of the code:
------------------------------------------------------------------------------------
Dim pad As String
Dim reg As String  
Dim db As Object
Dim dbName As String
pad         = Client.WorkingDirectory   

Hi,
Can anybody tell me the syntax to add items to a Combo box placed in Idea Scripting Dialog control?
 
Thanks,
Shafeer

Let's try that again.
 
 
Hi,
I'm trying to write a piece of code in ideascript that will open a word document and insert a file address at a bookmark location.
I'm getting an error message that the "Paramater is incorrect"
Any help on this would be appreciated
Thanks
Marc
Here's the code:
 QBMail = "D:\IDEA\Test.docx"
MyAdd = D:\TemporaryLocation"
Set wrdApp = CreateObject("Word.Application")
Set wrdDoc = wrdApp.Documents.Open(QBMail)

Hi Brian,
 
I get a strange Error message: "Analysis_PU_02_Duplicate_Name_Address_VATNumber",51,"Unable to find a schema in database."
 
I executed my script several times and 2 out of 5 times I get said error.
I always execute the script from the same folder and have the same working folder.
 
Here is my Code:
 
Function Analysis_PU_02_Duplicate_Name_Address_VATNumber
        On Error GoTo ErrHandler 

Hi Brian,
Love your site.