I have an Excel Spreadsheet and want to create an XML file for import. I need to generate the header and the tags with data but don't know the tag names on the sheet. Can I just use the row and column number?
In VB6 I used to be able to link to the sheet and poke data into a row and column but I understand that XML has replaced this in VB2010.
A simple example would be greatly appreciated.
