View Single Post
Old 08-21-2017, 08:42 PM
brolly brolly is offline
Join Date: Nov 2014
Posts: 2
Default vba translation (variant type)

I'm at loss for how to translate the following few lines of VBA code into Variant IndexOrNameOrID covers a variety of types.

IndexOrNameOrID can be an integer index (from zero to .Count-1)
IndexOrNameOrID can be a name that corresponds to FileProperty.Name
IndexOrNameOrID can be an ID that corresponds to FileProperty.ID

For background, this is from a class to return file metadata

  Property Get Item(ByVal IndexOrNameOrID As Variant) As FileProperty
                Set Item = VCOMObject.Item(IndexOrNameOrID)
            End Property
Reply With Quote