Keeping XML data in workbook?



Hi all,

I'm writing a VBA app to collect data from Excel workbooks and sheets and make a report, also in Excel format. Along with the report, I also need to store metadata on how the report was generated (what data was picked and from where).

If possible, I'd like to store the metadata in XML. So I wonder if it's possible to store XML data somewhere *inside* a workbook, preferably hidden from casual end users. If not, I imagine I could save it in rows and columns on a hidden sheet. But the question is: can I keep XML data inside a workbook? I'm using Excel 2003 and 2007.



A worksheet cell can contain 32,767 characters. Only the 1st 1024 is
visible. You can put data into a cell the then hide the entire worksheet so
it is not visible.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question