I need to create a text file.  Can you show me code from start to finish.  It needs to be these numbers sent to a text file without quotes and seperated by a tab.  EG.

1 tab 3 tab 4 tab 5 6 tab7 tab 8 tab 9 tab 10
11 tab 12 tab 13 tab 14 tab 15 tab 16 tab 17

Etc How do I do this?

Who is Participating?
VBDesignsConnect With a Mentor Commented:
Dim iFF as Integer
Dim iLoop as Integer

iFF = FreeFile

Open "c:\FileName.text" for Output as #iFF
For iLoop = 0 to (count-1)
    Write #iFF, , (cStr(iLoop) + Chr(9)) ' vbTab
Next iLoop

Close #iFF
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.