What are extended properties? It sounds like a Window's thing.
But you might want to look into AppleScript. Office2011 VBA file handling is not well suited to Macs, but the MacScript command allows VBA to use AppleScript in VBA, which is well suited to Mac files.