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

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

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

Hi Shishi,

Try vbTab or chr(9).

---
Regards,
Norman



"shishi" wrote in message
oups.com...
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

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

Hi Norman,

Thanks for yoiur reply. That did work.

shishi