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