I am having an issue with my script that i wrote to process a log file into an excel spread sheet. I am not sure what happened, but it nolonger seems to be processing correctly. I have didn't make any changes the script itself since the last time i used it.
The error that i am getting is : Script error: IDispatch pointers not allowed in expressions!
Here is the excert of the code that seems to be causing the problem.
code:
Gets $FileName
$oxl = CreateObject("EXCEL.application")
if @error = 0 $oXL.Visible = 1 ; make Excel visible to the user
$Rc = $oXL.Workbooks.Add ; add a new workbook
If Open(3,$FileName)=0 $oxl.sheets.add $oxl.Sheets("Sheet4").Select $oxl.Sheets("Sheet4").Name="Summary"
No this is just the first few lines of the script. The script itself is pretty long. I only put in the part where the error occurs. I am now wondering if it is the way i am launching Excel.
![[Big Grin]](images/icons/grin.gif){kind=icon}
