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

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

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

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