View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Get workbook version

it would be a member of the customdocumentproperty collection .

See Chip Pearson's page on this:

http://www.cpearson.com/excel/docprop.htm

--
Regards,
Tom Ogilvy

"Chriss" <une add wrote in message
...
I have a workbook that needs to be updated fequently and i need to know

the
version of the workbook in the code in order to copy and replace newer
versions. I tought of insering a 'Version' property in the

'personalisation'
panel that is in the property of the file itself. But i can't seem to be
able to get the value of this property in the code. The code would be in a
delphi program or in a macro in the workbook , i could use both methods.

If
you have any idea or research keywords that could help me plz tell me !

thanx !
chriss