Seperate columns with a tab??

  • Thread starter Thread starter lans
  • Start date Start date
L

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
 
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
 
Back
Top