The VBScript is pretty easy

Dim objExcel, objWorkbook

Set objExcel = CREATEOBJECT("Excel.Application")

Set objWorkbook = objExcel.Workbooks.Open (DTSGlobalVariables("gvFileName").Value)

objWorkbook.Sheets(1).Name = "TransactionDetails"

objExcel.Application.DisplayAlerts = False

objExcel.ActiveWorkbook.Save

objExcel.ActiveWorkbook.Close

Set objWorkbook = Nothing

objExcel.Application.DisplayAlerts =...