Thanks Shawn,
It did the trick, and now I see how Kix handles passing variables to COM functions.

I'm trying to take a directory of text files(logfiles created from one of my other scripts) and make them into something I can use for generating statistics on how long it takes the script to run on each machine. So i'm interfacing Kix with Excel a bunch now... i saw a post awhile back that involved creating Excel spreadsheets from Kix that is helping me a bunch.

Another question I have is... can I take a bunch of spreadsheets and combine them into just one workbook with multiple worksheets?