Help with output of FILE

[nota141]

I have these line of code in a program but it does not format the data so that the information is in colums

Open FILE For Append As #1
Print #1, fullname, objectname, fieldvalue,_
timenow, datenow, COMPUTERNAME, macaddress
Close #1
End Function

If you want to overwrite an existing file, use this:

Open "C:\FILE" For Output As #1
Print #1, fullname, objectname, fieldvalue, _
timenow, datenow, COMPUTERNAME, macaddress
Close #1

If you want to write to the end of it rather than overwriting it:

Open "C:\FILE" For Append As #1
Print #1, fullname, objectname, fieldvalue, _
timenow, datenow, COMPUTERNAME, macaddress
Close #1

For me, it is in columns..looks like this:

fullname      objectname    fieldvalue    timenow       datenow       COMPUTERNAME  macaddress

If that doesn't work, try using vbTab.

Print #1, fullname & vbTab & objectname & vbTab & fieldvalue _
& vbTab & timenow & vbTab &  datenow & vbTab & COMPUTERNAME & vbTab &  macaddress

[nota141]

Thanks for that the last one works