I have looked at many examples and have yet to find the solution to adding a column in Excel via a vb script. Need some expert help on this one. The code below is a small snippet of a larger problem but this is where it fails. The 5th line starting "selection" fails with and "Expected statement" error but i can't find a solution. All I want to do is open the spreadsheet, go to column B and insert a column. Simple but I can't get it to work. If I record a macro I basically get the same code and it works as a macro but not in a VB script. What am I missing?
Set objExcel = CreateObject("Excel.Application")
objExcel.Workbooks. Open strSourceFileName
Set objSheet = objExcel.ActiveWorkbook.WorkSheets(1)
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove