I need to export data into a sequential text file. 2

[StevieB01]

I need to export data into a sequential text file. Does anyone know how of some vba code that would do this?

Eg of file format.

Header Block
Text Block
Trailer Block
Enf of File Block



eg of a File with 2 records.

Header = ddmmccyy
Txn Ref = ABC001
Currency= GBP
Amount = 125.30
Trailer = EOT
Txn Ref = ABC002
Currency= USD
Amount = 99.30
Trailer = EOT
End of File = EOF

 

[Remou]

Have a look at FileSystemObject and Open Statement. One or other should suit.

 

[payback]

Have a look at thread181-987955