Wray Sisk commented on Importing text files with VBA – 3, asking if it could be modified to read tab delimited files.
It could be, and has been; download here: Text-in2.ZIP
It turned out to be a simple task; just the addition of one line to the splittext() function:
If LCase(Separator) = “tab” Then Separator = Chr(9)
To allow the use of other non displaying characters, and also so the code for tab (9) could be used instead of “tab” I also added:
If Val(Separator) > 0 Then Separator = Chr(CLng(Separator))
and changed the data type of separator from string to variant.
Whilst changing the spreadsheet I noticed that I had commented in the post about the very slow performance of Excel 2007 in clearing large ranges. There is a solution to this one, the slow down is associated with the Google Desktop COM add-in, and if you de-activate this the problem goes away. More details from Charles Williams here: Google Toolbar Slows Excel