Yes, use your Visual Basic program to run the Excel sofware, and open your CSV file.so do i need to change the way I coded the program to save the data?
After each change, first CLOSE the CSV file, then use your Visual Basic program to call Excel, load the CSV file, then save it as a XLS file, then CLOSE the XLS file. Now you always have an updated spreadsheet that can be opened and viewed by anyone else.
The problem with the CSV file conversion to XLS is that it may not be formatted and labeled as you need for your co-workers.
As Jesper says, a database file may be better suited for your needs. But probably your customers will prefer sticking with Excel.
Last edited: