How to compile a script

Hi folks,
 
Hoping you can help as I'm struggling to get this script to run and being fairly new to scripting (I've only compiled a couple before), I was hoping to get some help on what I'm doing wrong.
 
I've attached the script I'm trying to run, which is a composite of all the IDEA scripts for each stage of the process I want to automate. The problem I'm having is is keeps telling me I haven't defined my database names; I tried to do this using Dim but it still didn't work no matter what I entered so I removed it.
 
I also wanted to modify the script so that I can choose which files to import when the script is running, but can't seem to make it work
 
The only way I've ever been able to get a script to run before is to record the macro from start to end, but this process is more involved and I also want to get much better at script writing
 
Thanks in advance for any help anyone can offer :-)
Tammy