Hi forum,

What i am trying to accomplish:

I have an Excel spreadsheet containing file names, document numbers, file revision and state.

Based on document number, i need to search vault to locate the file and update Excel with correct revision and state.

The macro is working well, but i thought i'd throw in a check to see if there were more matching documents. The document number *should* be unique, but there are no guarantees, and i would like to be sure my spreadsheet is correct.

I am using this:

     sDocumentNumber = Range("G" & i).value

     search.AddVariable "Document Number", sDocumentNumber

     search.SetToken Edmstok_AllVersions, False

My check is simple, i run a counter on the search result, using GetNextResult.

However, i discovered i got two matches on the same document and the reason is because the value sDocumentNumber was present in two configurations.

It doesnt seem like i can specify which configuration to search for the variable value, i mean it would be pretty sweet to search for:

search.AddVariable "Document Number", sDocumentNumber,

Or

SetToken Edmstok_Configuration

I am looking for suggestions on how to solve this. Anyone done something like this?

Best regards

Martin