User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 402,789 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,813 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 137 | Replies: 0
Reply
Join Date: Jul 2008
Posts: 1
Reputation: matt_wroe is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
matt_wroe matt_wroe is offline Offline
Newbie Poster

Removing excel dependencies.

  #1  
Jul 22nd, 2008
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.
AddThis Social Bookmark Button
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum

All times are GMT -4. The time now is 10:19 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC