Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. Gustaf |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping XML data in workbook?
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. "Gustaf" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COPY WORKBOOK KEEPING FORMULAS AND TEMPLATES, BUT LOSING THE DATA | Excel Discussion (Misc queries) | |||
keeping formula the same in a workbook when adding a row to one sh | Excel Worksheet Functions | |||
keeping a toolbar attached to a workbook | Excel Programming | |||
Keeping a workbook hidden when opened via VBA??? | Excel Programming | |||
keeping VBA script with a workbook | Excel Programming |