Using VBA, how to concatenate exports to a text file (no overwrite !)

[Benouche]

Hi,

I need to periodically export to a text file datas from a report.
I don't want to overwrite the existing text file when I do this export, but only to add the new informations ...

How to do it ????
I guess it should be possible in a vba macros.

Thanks in advance !
Benouche

 

[pabloj]

To open a file for sequential access from VBA you use the Open statement:
Open filename For [Input, Output, Append] As filenumber
You must Close all files you Open before reopening the files for another type of operation. Stick to your guns

 

[chogben]

You could use the current date in the filename - just remember to format it first

strfilename="whatever" & format$(date,"yyyymmdd&quot & ".txt"