Seperate columns with a tab??

[lans]

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

 

[Chip Pearson]

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

 

[David McRitchie]

CHR(9)

 

[lans]

Hi David,

Great, thank you