OK. So I was able to get it working using VBScript.

BEGIN CODE:
Dim wbSource, wbTarget, xlApp, srcWorksheet, tgtWorksheet
Set xlApp = CreateObject("Excel.Application")
Set wbTarget = xlApp.Workbooks.Open("c:\temp\xl\target.xls")
Set wbSource = xlApp.Workbooks.Open("c:\temp\xl\source.xls")
Set srcWorksheet = wbSource.Worksheets(1)
Set tgtWorksheet = wbTarget.Worksheets(2)
srcWorksheet.Copy , tgtWorksheet
wbSource.Close True
wbTarget.Close True
Set wbSource = Nothing
Set wbTarget = Nothing
Set srcWorksheet = Nothing
Set tgtWorksheet = Nothing
Set xlApp = Nothing
END CODE


This will work for me if I dynamically re-write the value for 'wbTarget ' based on filenames specified by my kix script. I have a huge number of files to modify and this method is rather slow (about 2 seconds per file * 5000+ files). I can't seem to figure out how to convert the above VB syntax to Kix and Google as I may, I can't seem to find anyone else who has done it either. If anyone can point me in the right direction for rewriting this functionality in Kix, it would be greatly appreciated.
_________________________
"When fascism comes to America, it will be wrapped in the flag, carrying a cross."
Sinclair Lewis