Since you posted this to a Visual Basic forum but you say you don't know VBScript well, the first thing is to determine what your actual language is. Are you doing this in Visual Basic, Visual Basic for Applications, or VBScript?
[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]