SYLK: File format error opening transaction logs in Excel

[greenfingers]

Hi, I'm trying to automate the importing of the transaction logs into Excel, however I'm getting an error message:
"Excel has detected that ‘120110.txt’ is a SYLK file, but cannot load it."

Apparently this is due to a known Microsoft issue whereby any text file starting with capital letters "ID" as the first two characters inside the file (as with transaction logs) is assumed to be a SYLK file. As it is actually a text file, it throws up the error.
http://support.microsoft.com/kb/323626

Yikes! Any ideas how to get around this? I've tried Application.ScreenUpdating = False