[SOLVED] How To Specify A Tab Character In Excel Vba...

Maybe your like

+ Reply to Thread Results 1 to 3 of 3 How to specify a tab character in excel vba...

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
- Mark this thread as solved…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Linear Mode
- Switch to Hybrid Mode
- Switch to Threaded Mode

08-09-2005, 11:05 PM #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
Register To Reply
08-09-2005, 11:05 PM #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 >
Register To Reply
08-10-2005, 12:05 AM #3 shishi Guest
Re: How to specify a tab character in excel vba...

Hi Norman, Thanks for yoiur reply. That did work. shishi
Register To Reply

+ Reply to Thread « Previous Thread | Next Thread »

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

Forum Rules

-- vB4 Default Style -- Mobile Style Premium -- Lightweight -- Fully Optimized -- Mobile_V1

All times are GMT -4. The time now is 05:03 AM. Search Engine Friendly URLs by vBSEO 3.6.0 RC 1

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