Does anyone know how to remove a specified Custom Document Property
from an Excel workbook using VBA?
Adding is easy. There is a method to Add.

I tried to use the Macro Recorder while trying to delete a property
manually, but it did not record anything useful.
Thank you in anticipation.

Hi JAC,

Suppose I already have a custom property named "CustomNumber" in the
workbook object wbk. To erase it just write:

Call wbk.CustomDocumentProperties("CustomNumber").Delet e

Custom Properties work like any other collection. You should take a look to
the help file of the collection object.

--
Carlos


"JAC" wrote:

Does anyone know how to remove a specified Custom Document Property
from an Excel workbook using VBA?
Adding is easy. There is a method to Add.

I tried to use the Macro Recorder while trying to delete a property
manually, but it did not record anything useful.
Thank you in anticipation.

There is also a Delete method. Try something like the following:

Dim DocProps As Office.DocumentProperties
Dim DocProp As Office.DocumentProperty
Set DocProps = ThisWorkbook.CustomDocumentProperties
Set DocProp = DocProps("MyProp") ' Here it is.
Debug.Print DocProp.Value
DocProps.Item("MyProp").Delete ' Now it's gone

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Wed, 22 Oct 2008 14:08:26 -0700 (PDT), JAC
wrote:

Does anyone know how to remove a specified Custom Document Property
from an Excel workbook using VBA?
Adding is easy. There is a method to Add.

I tried to use the Macro Recorder while trying to delete a property
manually, but it did not record anything useful.
Thank you in anticipation.

On 22 Oct, 22:43, Carlos wrote:
Hi JAC,

Suppose I already have a custom property named "CustomNumber" in the
workbook object wbk. To erase it just write:

Call wbk.CustomDocumentProperties("CustomNumber").Delet e

Custom Properties work like any other collection. You should take a look to
the help file of the collection object.

--
Carlos

"JAC" wrote:
Does anyone know how to remove a specified Custom Document Property
from an Excel workbook using VBA?
Adding is easy. There is a method to Add.

I tried to use the Macro Recorder while trying to delete a property
manually, but it did not record anything useful.
Thank you in anticipation.

Thanks guys.

I don't know why I didn't think of that. It's so blindingly obvious
when you think about it.

I hope that others find it useful that the problem has been aired.