Storing XML In Workbook
This does not work since it will not let me export it again.
It it meta data, but I can't store it in a custom property OR a cell because
the xml string is too long. Is there nowhere in excel with unlimited string
lengths?
"NickHK" wrote in message
...
Ray,
Excel 2002 and up can open/save XML files directly. You could hide it
after
opening.
NickHK
"Ray Price" wrote in message
...
Hi All,
I am trying to store XML data in a workbook hidden from the users. It's
basically meta-data. I was using the custom properties, but it seems
there
is a limit of 256 characters.
Can anyone else suggest a good place for meta data?
Thanks!
|