Got this script from the scripting guy, but having problems getting it to save without any interaction. I want the script to open up a fixed field spreadsheet and save it as a .csv. Just need a statement to save. Thanks!
Const xlFixedWidth = 2
Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True objExcel.Workbooks.OpenText _ "C:\Documents and Settings\User\Desktop\New Folder\Test1",,,xlFixedWidth,,,,,,,,,Array(Array(0,1),Array(12,1),Array(22,1))