Removing excel dependencies.

[matt_wroe]

Hello,

I have written a program in visual basic 6 for controlling pumps on an addressed rs232 or rs485 network. Currently the names and addresses of these pumps are stored in an excel file which can then be edited by the software at runtime to add/remove pumps from the network. It is also used to load control arrays for each pump.

This all works well however i now want to remove this dependency on excel by replacing it with a text file (other suggestions welcome). So is it possible to store data in a text file such that "rows" and "cells" of data can be deleted and added at runtime? and are there any like for like commands to replace:

LoadExcel = oSheet.Cells(1, 4).Value

oSheet.Rows(Row).Delete

and perhaps to count the number of records as well?

Thanks for any help you might be able to give.

Matthew

ps, This is my first vb program so sorry if i'm being a bit dumb.