In Access I use VBA to open a single worksheet Excel file and save it as a text file. I never had a problem with it but it gives the above error on a user's PC in a different location.
Set myXL = New Excel.Application
myXL.Visible = False
Set wb = myXL.Workbooks.Open(strXLfile)
myXL.DisplayAlerts = False 'don't want dialog box
.SaveAs Filename:=strNewName, FileFormat:=xlTxtFileType
myXL.DisplayAlerts = True