CustomDocumentProperties disappear after save
 

I've never had this problem using VBA, and I use it frequently.

Before saving, can you see the properties in the workbook manually? (File
menu Properties)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Nay" wrote in message
...
Hi
The CustomDocumentProperties element is disapear after dynamiclly open a
workbook and save it by (use Interop.excel.workbook). I use Excel 2003
and
vsto 2005

The steps I do are as follow:
-I open an excel file by code as xml document and
-Via the DOM I add to the "o:DocumentProperties" Element
the "CustomDocumentProperties" element and save it, so the workbook looks
like :
"...<o:DocumentProperties<CustomDocumentPropertie s xmlns=""My meta data-
My meta data 2 ***</CustomDoacumentProperties</o:DocumentProperties..."
- Then I open the workbook with a interop.excel.workbook(open method), and
save it use the same object.
(If I open the file manuall I see in documentproperties only the version
element)

What do I miss?

CustomDocumentProperties disappear after save
 

I missed that you were starting in XML, until hitting the Send button. I
have no experience using this approach.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jon Peltier" wrote in message
...
I've never had this problem using VBA, and I use it frequently.

Before saving, can you see the properties in the workbook manually? (File
menu Properties)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Nay" wrote in message
...
Hi
The CustomDocumentProperties element is disapear after dynamiclly open a
workbook and save it by (use Interop.excel.workbook). I use Excel 2003
and
vsto 2005

The steps I do are as follow:
-I open an excel file by code as xml document and
-Via the DOM I add to the "o:DocumentProperties" Element
the "CustomDocumentProperties" element and save it, so the workbook looks
like :
"...<o:DocumentProperties<CustomDocumentPropertie s xmlns=""My meta
data-
My meta data 2 ***</CustomDoacumentProperties</o:DocumentProperties..."
- Then I open the workbook with a interop.excel.workbook(open method),
and
save it use the same object.
(If I open the file manuall I see in documentproperties only the version
element)

What do I miss?