embedding / structured storage?

R

Richard Bond

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
 
D

Dana DeLouis

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
 
R

Richard Bond

Thanks,

I like the idea of CustomDocumentProperties, however I think I need more
than 255 characters. Is there another way?

regards,

Richard
 
D

Dana DeLouis

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
 
Top