Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
embedding / structured storage?
I have a report definition (list of parameters - could be
"xmlified"/serialised) that I would like to store within an excel file. Can someone point me in the direction of some documentation on how to do this / pros and cons. thanks, Rich |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
embedding / structured storage?
You could store it in a cell. Other options would be to store it as a
defined name. Sub Demo1() ActiveWorkbook.Names.Add Name:="ReportDef", RefersTo:="=""xmlified/serialised""" End Sub Another option would be to store it as a Custom Document Property. You can view it under <File <Properties and then the Custom tab. Sub Demo2() ThisWorkbook.CustomDocumentProperties.Add _ Name:="ReportDef", _ LinkToContent:=False, _ Type:=msoPropertyTypeString, _ Value:="xmlified/serialised" End Sub HTH Dana DeLouis "Richard Bond" wrote in message ... I have a report definition (list of parameters - could be "xmlified"/serialised) that I would like to store within an excel file. Can someone point me in the direction of some documentation on how to do this / pros and cons. thanks, Rich |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
embedding / structured storage?
Thanks,
I like the idea of CustomDocumentProperties, however I think I need more than 255 characters. Is there another way? regards, Richard "Dana DeLouis" wrote in message ... You could store it in a cell. Other options would be to store it as a defined name. Sub Demo1() ActiveWorkbook.Names.Add Name:="ReportDef", RefersTo:="=""xmlified/serialised""" End Sub Another option would be to store it as a Custom Document Property. You can view it under <File <Properties and then the Custom tab. Sub Demo2() ThisWorkbook.CustomDocumentProperties.Add _ Name:="ReportDef", _ LinkToContent:=False, _ Type:=msoPropertyTypeString, _ Value:="xmlified/serialised" End Sub HTH Dana DeLouis "Richard Bond" wrote in message ... I have a report definition (list of parameters - could be "xmlified"/serialised) that I would like to store within an excel file. Can someone point me in the direction of some documentation on how to do this / pros and cons. thanks, Rich |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
embedding / structured storage?
Could you break the string into smaller units and store the names like
"Report1", "Report2", etc? When you retrieve the strings, you could than join them together. Or perhaps just a dedicated Cell. Dana DeLouis "Richard Bond" wrote in message ... Thanks, I like the idea of CustomDocumentProperties, however I think I need more than 255 characters. Is there another way? regards, Richard "Dana DeLouis" wrote in message ... You could store it in a cell. Other options would be to store it as a defined name. Sub Demo1() ActiveWorkbook.Names.Add Name:="ReportDef", RefersTo:="=""xmlified/serialised""" End Sub Another option would be to store it as a Custom Document Property. You can view it under <File <Properties and then the Custom tab. Sub Demo2() ThisWorkbook.CustomDocumentProperties.Add _ Name:="ReportDef", _ LinkToContent:=False, _ Type:=msoPropertyTypeString, _ Value:="xmlified/serialised" End Sub HTH Dana DeLouis "Richard Bond" wrote in message ... I have a report definition (list of parameters - could be "xmlified"/serialised) that I would like to store within an excel file. Can someone point me in the direction of some documentation on how to do this / pros and cons. thanks, Rich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Structured references between worksheets | Excel Discussion (Misc queries) | |||
How do I create fee structured sliding scale? | Excel Discussion (Misc queries) | |||
Structured reference does not return correct value | Excel Worksheet Functions | |||
Structured references & Quickbooks data | Excel Worksheet Functions | |||
object or structured orientated?? | Excel Programming |