VBScript & Excel - Convert Tab Delimited Files to Excel Files

I am trying to write a vbscript that will open a collection of .tsv (tab-delimited) files in Excel, change the formatting of the files (i.e., insert rows, change font size, add column headings, etc.), and then save the files as fully-functional Excel files. At this point, the vbscript I have written will do all of the formatting tasks I require. It will not, however, save the .tsv files as fully-functional Excel files. I’ve tried solutions suggested in the Automating Office Applications section of MSDN’s site without any luck. It seems like I’ll need to modify

objXL.ActiveWorkbook.SaveAs (“filename”)

to specify somehow XLFormat.

I stumbled across this site while searching for a way to accomplish this task and I’m hoping that someone here will be able to help point me to a web site that includes informatino on how to get a vbscript to change the format when saving from Excel. Thanks in advance.

ActiveWorkbook.SaveAs Filename:="C:\filename.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False

The Ace!!!
Judge Not Less Thee Be Judged Thyself.

This should work:

objXL.ActiveWorkbook.SaveAs "c:\myfile.xls", xlNormal

Medialint,

Thank you for your suggestion. Unfortunately, appending --> , xlNormal <-- to objXL.ActiveWorkbook.SaveAs "c:\myfile.xls" returns an error... SaveAs method of Workbook class failed.

objXL.ActiveWorkbook.SaveAs "C:\temp1234.xls",FileFormat=xlExcel9795