embedding / structured storage?

[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

 

[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

 

[Richard Bond]

Thanks,

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

regards,

Richard

 

[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