I don't see where in your string you define a macro. See the MapDrive() UDF as it demonstrates how to resolve macros inside a text string.
_________________________
There are two types of vessels, submarines and targets.