I have written some inventory control programs using a comma deliniated file (.txt) as the running database. Can a VB executable access an Excel file the same way?
Yes, But the code won't be the same as with CSV (Comma Delimited) File. Here are a couple of links on concepts. These links focus on using word, but excel is the exact same concept. Once you understand how the tutorials (creating office objects, and automating office apps), we can dive right into porting over your code to work with excel (if you want).