I'm trying to open multiple * delimited text files in excel (as multiple workbooks). I'm trying to figure out how to open a file using * as a delimited file, and didn't find much help on msdn.

code:

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

Thanks in advance!

Jim