Revision number

C

Charlotte E.

There's an option to read a revision number of the workbook with:

MsgBox ThisWorkbook.BuiltinDocumentProperties("Revision number")

-...but how to set this 'Revision number'???

If I use...

ThisWorkbook.BuiltinDocumentProperties("Revision number") = "v1.00"

....I get an error???


CE
 
C

Claus Busch

Hi Charlotte,

Am Mon, 27 May 2013 14:42:17 +0200 schrieb Charlotte E.:
ThisWorkbook.BuiltinDocumentProperties("Revision number") = "v1.00"

this property doesn't accept strings
Try:
Dim ObjBDP As Object

Set ObjBDP = ThisWorkbook.BuiltinDocumentProperties
ObjBDP("Revision number") = 1#

or:

ThisWorkbook.BuiltinDocumentProperties(8) = 1


Regards
Claus Busch
 
W

witek

Charlotte said:
There's an option to read a revision number of the workbook with:

MsgBox ThisWorkbook.BuiltinDocumentProperties("Revision number")

-...but how to set this 'Revision number'???

If I use...

ThisWorkbook.BuiltinDocumentProperties("Revision number") = "v1.00"

...I get an error???


CE


You can set it to number but not string even if property type says it is
msoPropertyTypeString

That is Microsoft.
 
C

Charlotte E.

You can set it to number but not string even if property type says
it is msoPropertyTypeString


Thanks - that explains it ...


CE



Den 27.05.2013 15:28, witek skrev:
 
C

CellShocked

You can set it to number but not string even if property type says it is
msoPropertyTypeString

That is Microsoft.

One can manually set a 'version number' as one of the extended file
properties from within file manager (right click on the file name). so
that property, once set, should show up somewhere within one of the
property dialog/listings within the document itself, providing knowledge
of the location. I currently do not know where it resides within the
document. Only from the file level..
 
W

witek

CellShocked said:
One can manually set a 'version number' as one of the extended file
properties from within file manager (right click on the file name).

Excel will not read it if you set it to something else than number.
It will show it as damaged file.



so
that property, once set, should show up somewhere within one of the
property dialog/listings within the document itself, providing knowledge
of the location. I currently do not know where it resides within the
document. Only from the file level..


it is in core.xml file in unzipped doc.

The standard say it is string

<xs:element name="revision" minOccurs="0" maxOccurs="1" type="xs:string"/>

Microsoft knows better what it should be.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top