ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   WorkSheet customproperties (https://www.excelbanter.com/excel-programming/397248-worksheet-customproperties.html)

nay

WorkSheet customproperties
 
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


Jim Rech

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
|




All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com