VBA: How can I write to the next column in a test.wks file?

[Alex00001]

Hi,

I am not an experienced user and I have a problem writing output from a simulation model to a .wks format file. I get VBA to make the file and write data in it. Until now I have made the following code, but it only writes data to the first column. Can anybody tell me how to write data to the second and third etc columns?
Writing to an excel file is not possible because of file corruption caused by the simulation software.

Below the code I have tried sofar. But everything I write ends op cramped in first column.

Thanks a lot for your help!

  Open "test.wks" For Output As #1
    
        Write #1, OutputFileName
        Write #1, 'Write blank line.
        Write #1, 'Write blank line.
        Write #1, 1, 2
        Write #1, 1; Tab(10); 2
        Print #1, "This is a test"  ' Print text to file.
        Print #1,   ' Print blank line to file.
        Print #1, "Zone 1"; Tab; "Zone 2"   ' Print in two print zones.
        Print #1, "Hello"; " "; "World"     ' Separate strings with space.
        Print #1, Spc(5); "5 leading spaces "   ' Print five leading spaces.
        Print #1, Tab(10); "Hello"  ' Print word at column 10.
        
close #1

 

[GlennUK]

It looks like you are writing a text file not a "wks" file. Just making the file extension ".wks" in your filename doesn't mean you are writing into "wks" format. Set up your layout in an empty new worksheet and then save that as filetype WKS.

 

[Alex00001]

Could you give me some pointers on how to set the file up in wks format?
I'd be gratefull

 

[GlennUK]

As I said, put the data in a worksheet and ... "save that as filetype WKS". When you do File/Save As ... change the Filetype in the "Save As Type" dropdown to "WKS".