View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default WorkSheet customproperties

I saved a workbook as an XML spreadsheet in Excel 2003 and a custom property
(named 'abc' with a value of 'def' ) I put in it was saved:

<CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office"
<abc dt:dt="string"def</abc
</CustomDocumentProperties

--
Jim
"Nay" wrote in message
...
| Hi
| I have an excel workbook that is opened with automation
| Few CustomProperties are added(using worksheet.CustomProperties.add(...)
| The source file is binary excel but I use workbook.saveas... to save it to
| another location as xml !!!
|
| Another application open the new workbook(the xml one) and try to read the
| CustomProperties but it seems like there are no CustomProperties, actually
| its count is 0.
| If I open the file as xml(not with excel) I can't find the
customproperties
| as well.
| Any idea?
|
| thanks, Nay
|