VBScript Text To Columns

FAQ
1

When you want to make text to columns in Excel, you can use the vbs code below.

Set objXLApp = CreateObject("Excel.Application")
objXLApp.Visible = false
Set objXLWb = objXLApp.Workbooks.Open("D:\RPA_Projeler\ZES_STOK\2022\02\Gönderilenler\ZES_STOK_2022.02.22.xlsx")
Set oSheet = objXLWb.Worksheets(1) 
 
oSheet.Range("C:C").TextToColumns 
objXLWb.save
objXLWb.close false
objXLApp.Quit

Set objXLWb = nothing
Set objXLApp = nothing