View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ray Price[_3_] Ray Price[_3_] is offline
external usenet poster
 
Posts: 2
Default 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!