All I am doing is opening the xls file and then immediately saving it as a tab delimited text file to parse with routines I use all the time. So if the answer to my question is NO, then any suggestions on my small task would be appreciated.
Dim objExcel As Excel.Application
Dim objWorkBook As Excel.Workbook
' sFilename is string for xls file
' sOrders is string for resulting txt file
Set objWorkBook = objExcel.Workbooks.Open(sFilename)
objExcel.DisplayAlerts = False
objWorkBook.SaveAs sOrders, FileFormat:=xlText
objWorkBook.Close True
Set objWorkBook = Nothing
Thanks

New Topic/Question
Reply



MultiQuote



|