Inserting a line of text into a Text file using VB

[Guest_imported]

Does anybody know how to code a function to insert a line of text into a text file and then save the change. Im sure it can be done but don't know how.

Thanks

 

[JohnYingling]

I do not know of any "insert" to a texct file. You can read the file, copy the input records to an output file while writing the new record to output at the appropriate (to you) place.

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[Guest_imported]

Thanks for the reply. Those websites are excellent.

I thought TextStream objects could do this in VBA but it looks like I need to use VB.


Cheers

Frank

 

[BlackKnight]

Hi,

The textstream object does not have an insert method. You can either use .READALL and use instr() to find where the insertion point is, rebuild the string, and output it.

If the textfile is composed of fixed length records you may open the file for random access and put the chunks back together.

Have a good one!
BK

 

[JohnYingling]

FrankLT

Thanks

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript