Just as a side note to the already perfect replies from the others: macros do not have dollarsign-expansion applied to them. $(vVar) only works in QV script and in expressions, code for which the QlikView engine is responsible.
AFAIK macro's are handled by the standard Microsoft VBScript interpreter, that has no idea what $-sign substitution is actually. You'll have to pass through the QV object model to pick up variable values. Various methods to do this are provided in previous replies.