code:

---

$Rc = $oXL.WORKBOOKS.OPEN(FILENAME:="C:\UPLOAD\CHARTING15.TXT",FORMAT:="6",DELIMITER="*")

---

Thanks in advance!

Jim

Try this:

$oXL.WORKBOOKS.OPEN("C:\UPLOAD\CHARTING15.TXT",,,6,,,,,"*")

-Shawn

Open Method

-Shawn

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?

You mean, enumerate a bunch of xls files in a directory and merge them into one workbook (single xls file) ?

-Shawn

Here's a quick take on this - point $filepath to a directory containing many .xls files and have at it ... I purposefully just exited the script at the end just for debugging reasons, so it's not finished by any stretch ...

break on

$filepath = "c:\xls" ; <- change this to point to a folder containing many .xls files

$xls = createobject("excel.application")

$xls.visible = 1

$wb1 = $xls.workbooks.add ; this is were we'll copy all our sheets

$filename = dir("$filepath\*.xls") ; start the enumeration
while $filename and not @error
 $wb2 = $xls.workbooks.open("$filepath\$filename") ; open the workbook
 for each $worksheet in $wb2.worksheets
   $=$worksheet.copy($wb1.worksheets("sheet1")) ; copy the sheet to wb1
 next
 $=$wb2.close
 $filename = dir()
loop

; purposefully exit at this point without saving

exit 1

Hope this helps !

-Shawn