Try
FileFormat:=xlTextPrinter
instead of
FileFormat:=xlText

It's only a guess as I don't know what's being imported into the
headers and contents of columns B,C,etc. therefore I don't know what
ends up in Column A. Getting the macro helped, but as mentioned
before, a copy of "the data as it is about to be saved" would have
allowed me to be sure, and saved me a lot of my time (but you're not
paying for it so of course, it matters not), and you'd have got a
definitive answer sooner.