Seperate columns with a tab??
 

Dear all,

I have I think a small problem but a very irritating one. I hav
written a VB program (macro) to import a text datafile in
spreadsheet. When seperating the columns I first used a comma in my V
program (SEP = ","). But now I need a tab. What symbol can I use fo
that (A space is also easy, you then use SEP = " ", but what to us
when you need a tab?). Thank you very much for your reply. I am no
very experienced.

Best regards

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Seperate columns with a tab??
 

Lans,

You can get a tab character by using vbTab or Chr(9). For example,

Sep = vbTab
' or
Sep = Chr(9)



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"lans" wrote in message
...

Dear all,

I have I think a small problem but a very irritating one. I have
written a VB program (macro) to import a text datafile in a
spreadsheet. When seperating the columns I first used a comma in my VB
program (SEP = ","). But now I need a tab. What symbol can I use for
that (A space is also easy, you then use SEP = " ", but what to use
when you need a tab?). Thank you very much for your reply. I am not
very experienced.

Best regards.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Seperate columns with a tab??
 

CHR(9)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"lans" wrote in message ...

Dear all,

I have I think a small problem but a very irritating one. I have
written a VB program (macro) to import a text datafile in a
spreadsheet. When seperating the columns I first used a comma in my VB
program (SEP = ","). But now I need a tab. What symbol can I use for
that (A space is also easy, you then use SEP = " ", but what to use
when you need a tab?). Thank you very much for your reply. I am not
very experienced.

Best regards.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Seperate columns with a tab??
 

Hi David,

Great, thank you

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com