Keeping XML data in workbook?

G

Gustaf

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.

Gustaf
 
J

Joel

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

Similar Threads

Storing XML In Workbook 4
XML Data Island in Excel Workbook? 2
Get calling workbook path? 2
Extract data from XML file and populate them into cells 1
Storing configuration data in XLA file 2
How do you program Excel to import/export data to XML files 4
Microsoft Excel 2007- XML maps in my workbook are not exportable 1
Read data from workbook without showing it? 7

Top