Read,Show,Update,Format & Save a text file.
 

Hi,

I have a text file "Companies.txt" with data exactly like
BUB
CHC
ATR
CHC

I have a main form frmMain on my Excel sheet with a command button
"Add/Edit Companies" which when pressed should show the text on another
form frmEdit to edit companies.

The frmEdit has two command buttons "Save" and "Close".

The user should be able to add, delete, update or change the data.
After adding/editing data when the user presses "Save" the contents
should get saved into "Companies.txt". Also these contents should be
formatted and written to a new text file "FI - Companies.txt" as
follows:
C#BUB##
C#CHC##
C#ATR##
C#CHC##

But when "Close" is pressed nothing should happen.

Can someone please guide me on achieving this one.
Many Thanks
Bristol