How to specify a tab character in excel vba...

[shishi]

Hi all,

I am trying to use Chip Pearson's code for extracting text files.
This is the link for it
http://www.cpearson.com/excel/imptext.htm
I like this code very much. It will allow you to specify any delimiter
character. However, I don't know how to specify a tab character in vba.
I tried "\t" like in unix, perl etc. No luck. So could you please tell
me how can I specify a tab character in vba.
Thanks in advance,

shishi

 

[Norman Jones]

Hi Shishi,

Try vbTab or chr(9).

 

[shishi]

Hi Norman,

Thanks for yoiur reply. That did work.

shishi