+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    shishi
    Guest

    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


  2. #2
    Norman Jones
    Guest

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

    Hi Shishi,

    Try vbTab or chr(9).

    ---
    Regards,
    Norman



    "shishi" <[email protected]> wrote in message
    news:[email protected]...
    > 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
    >




  3. #3
    shishi
    Guest

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

    Hi Norman,

    Thanks for yoiur reply. That did work.

    shishi


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1