IDEAScript Questions

Hi,
I have another question about scripting. I created a bunch of small scripts that check the dataset for repetition or missing information and so on. Afterwards I integrated some of the scripts into a different larger script, which runs about 3-5 of my initial small scripts. I called those integrated scripts "routines", which we will use to do a certain audit procedures from our audit plan.
As I create more and more smaller scripts I am in danger of losing track of where I integrated them into the routines.

Hi,
is it possible to create a script that will automatically create an arrangement of layers for the amount column of my dataset?
By the way... this forum is an awesome idea!

Someone at the IDEA site posted a question in which they wanted to import several excel files, add the filename to the file and then resave the excel spreadsheet.

I came up with this script which will hopefully help them up.  It first asks for the folder in which the excel files are stored, it then imports all the excel files, in this case each file had a worksheet called school risks, so anyone using this script would have to modify the worksheet name and the new field name.

Option Explicit

Sub Main
&nbsp