i have this vbscript that i do not need to open the file since it will be opened by another apps
i tried to replace open as run but it don’t work
Please help with this syntax
Set objExcel = CreateObject(“Excel.Application”)
Set wb = objExcel.Workbooks.Open(“C:Tempabc.xlsx”)
wb.Worksheets(“Sheet1”).Range(“I:N”).EntireColumn.Delete
i tried to replace open as run but it don’t work
Set objExcel = CreateObject(“Excel.Application”)
Set wb = objExcel.Workbooks.Run(“C:Tempabc.xlsx”)
wb.Worksheets(“Sheet1”).Range(“I:N”).EntireColumn.Delete
New contributor
Sam Yang is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.