Member Avatar for doug98

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?

  • 2 Contributors
  • 1 Reply
  • 170 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Comatose
Member Avatar for Comatose

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).

http://www.daniweb.com/tutorials/tutorial51307.html
http://www.daniweb.com/tutorials/tutorial51315.html

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.