(Previously posted in the Office forum, by mistake)
I'm looking for the best approach to find a way to export data from a working copy spreadsheet to a formatted output worksheet, both of which are Excel 2000.
Realizing this would be a lot easier if I could use Excel XP, but I'm stuck with having to use Excel 2000 for now.
So far I've used a VBA routine to identify named ranges within the working copy and generate XML data for each range. Now I'm stuck.
I've been all over the web looking for solutions and the more I search the more I get confused. I've found many solutions for creating a brand new worksheet from XML data but with my limited knowledge of XML, XLST, etc., I need to find a way to populate an existing, formatted sheet, somehow mapping the input fields to the output fields.
I'm not sure if I should create some type of dataset first then read that into the template? How? VBA/ADO?
Or is there an easier way to import the data directly into the template using the raw XML data? Is there a more appropriate/easier datasource I could use?
To complicate matters, both the input and output workbooks contain multiple sheets and multiple column headings representing relevant sections of data. The output also contains summary data from the input sheet.
Any guidance at all on this issue would be greatly appreciated!
I'm looking for the best approach to find a way to export data from a working copy spreadsheet to a formatted output worksheet, both of which are Excel 2000.
Realizing this would be a lot easier if I could use Excel XP, but I'm stuck with having to use Excel 2000 for now.
So far I've used a VBA routine to identify named ranges within the working copy and generate XML data for each range. Now I'm stuck.
I've been all over the web looking for solutions and the more I search the more I get confused. I've found many solutions for creating a brand new worksheet from XML data but with my limited knowledge of XML, XLST, etc., I need to find a way to populate an existing, formatted sheet, somehow mapping the input fields to the output fields.
I'm not sure if I should create some type of dataset first then read that into the template? How? VBA/ADO?
Or is there an easier way to import the data directly into the template using the raw XML data? Is there a more appropriate/easier datasource I could use?
To complicate matters, both the input and output workbooks contain multiple sheets and multiple column headings representing relevant sections of data. The output also contains summary data from the input sheet.
Any guidance at all on this issue would be greatly appreciated!