For my German final project I need to access some excell spreadsheets in VB. I figured out how to load the data in from an XML file, but I have no idea how to access the data by cell. Does anyone know? I am mainly using VB.NET for this, but may use VB 6.0 if you know something that works in 6.0 and not .NET. Can anyone help me out?
You shouldnt really post VB questions here........but as I'm working with VB at the moment, I'll try help
Here's a VB6 program that acts as a quick viewer for excel sheets.....it opens a document via automation and then scans the first 200 or so cells and uses the data found to populate a flexgrid control
