how to write data and tab

[cpanon]

Hello
I do not know how to write content of an array and a tab to a file. I have all the file handling working, my questions is how to do the actual write. The items in the array are all text strings but this doesnt work
write #1 myRng(i,j) & vbTab
with the obvious assumptions. I just want to write the array value and a tab to my tab-delimited file in the next location. tia.

 

[SkipVought]

Hi,

Do you have an OPEN statement?

Have you checked VBA Help on the Write # statement?

What specifically is not working?

Skip,

_[red][/red]

 

[Bong]

write #1[red],[/red] myRng(i,j) & vbTab ?

_________________
Bob Rashkin

 

[cpanon]

Hi All
I have fixed this with the following

For i = (LBound(stringArray) + 1) To UBound(stringArray)
        Debug.Print stringArray(i)
        Print #fnum, (stringArray(i) & vbTab);
    Next
    Print #fnum, vbTab
Close #fnum

I was surprised that it really needed the ";" to write the values as fields. I found that out from a MS Tip on

http://support.microsoft.com/kb/183311