creating a TEXT FILE

[Qroozn]

i have created an excel program and am trying to create an interace which links it to a unix system via a text file.

I know the text to go into the text file...

but dont know how to generate a text file from within excel.

any ideas?
This message was edited by Qroozn on 2002-04-23 18:35

 

[Mark O'Brien]

I pulled this from VBA help for the "Write" command. Also have a look for "OpenAsTextStream" and "OpenTextFile". This should get you started. Also, offhand, I know that you may run into problems since UNIX textfiles don't use carriage returns to end a line. (can't remember what though.

<pre>This example uses the Write # statement to write raw data to a sequential file.

Open "TESTFILE" For Output As #1 ' Open file for output.
Write #1, "Hello World", 234 ' Write comma-delimited data.
Write #1, ' Write blank line.

Dim MyBool, MyDate, MyNull, MyError
' Assign Boolean, Date, Null, and Error values.
MyBool = False : MyDate = #February 12, 1969# : MyNull = Null
MyError = CVErr(32767)
' Boolean data is written as #TRUE# or #FALSE#. Date literals are
' written in universal date format, for example, #1994-07-13#
'represents July 13, 1994. Null data is written as #NULL#.
' Error data is written as #ERROR errorcode#.
Write #1, MyBool ; " is a Boolean value"
Write #1, MyDate ; " is a date"
Write #1, MyNull ; " is a null value"
Write #1, MyError ; " is an error value"
Close #1 ' Close file.</pre>

 

[Qroozn]

Thnks heaps.
I'll need to muck around with it.

I'm sure the bosses will sh!t their pants when they see what their Manufacturing trainee has managed to do.