SAPIEN Forums

Need help getting this file to save. I am wanting to use this script to open a text file and save it as a .csv and then close. The file is in a fixed field format. Thanks for any help you can provide. Should be easy, but this is my first script. Thanks.

Const xlFixedWidth = 2
Set objExcel = CreateObject("Excel.Application")objExcel.Visible = TrueobjExcel.Workbooks.OpenText _ "C:Documents and Settingsspa2329DesktopNew FolderTest1",,,xlFixedWidth,,,,,,,,,Array(Array(0,1),Array(12,1),Array(22,1))objExcel.Workbooks.Open.SaveA("d:appsbedtrackertest1.csv")objExcel.Quit

objExcel.ActiveWorkbook.SaveAs "d:appsbedtrackertest1.csv"

Thanks Joel. That worked great. Does anyone know how I can save it without user intervention?

Thanks.

I dont want it to ask for confirmation that I would like to save or overwrite the existing file.
Thanks

The saveas method has a grip of parameters for it. I think it does have one that you can pass to overwrite, etc.. Lookup the method on MSDN.

It should be
objExcel.ActiveWorkbook.SaveAs "d:appsbedtrackertest1.csv", TRUE

Just happened to remember it as I don't use Excel much either. Databases are easier.

It takes a village - good luck.