aerodoc
03-09-2014, 09:03 AM
I want to create a simple way to export data from an XLS spreadsheet to XML. Then, at a later date, read the XML data back into the XLS sheet. But I don't want to take all of the data of the spreadsheet, just a little bit. Think of the spreadsheet as the "brain" and the XML just as some basic inputs. It would need to be compatible with older versions of Excel (back to 2003).
Basically, I just want one button to do an export XML and another button to read XML data in. As a simple example, I just want to do this for cells between (A1 and C5) and (D1 and E10)...even though there is much more data in the sheet.
I am not very familiar with XML (obviously) so any help is greatly appreciated :)
Basically, I just want one button to do an export XML and another button to read XML data in. As a simple example, I just want to do this for cells between (A1 and C5) and (D1 and E10)...even though there is much more data in the sheet.
I am not very familiar with XML (obviously) so any help is greatly appreciated :)