CustomDocumentProperties (XP pro, Excel 2003 UK)

Topic

New Reply

Hi,

To verify that a workbook has a certain origin, I need to check for a CustomDocumentProperty that is always being set upon creation of the workbook.
However, if I just try to set it like:

string = ActiveWorkbook.CustomDucomentProperties(“LookMeUp”)

and the Prop doesn’t exist, I just get an ‘error 5’ (“Invalid procedure call or argument”) in return.

As ‘error 5’ is rather generic and can occur in multiple other situations, I’m reluctant to use it here.
Would anyone know of another better way to catch or workaround this kind of situation??

TIA

Reply | Quote

Replies

I always use a function for this. My function loops through all CustomDocumentProperties comparing their name to the one I am looking for, and returns the value and a status.

StuartR

Reply | Quote

Thanks Stuart

It sounds viable, I may actually even have done something similar before… / ;o)

Reply | Quote

But if the error occurs on that particular line you’re quite sure the property isn’t there, right?

Reply | Quote