http://blogs.msdn.com/b/clintcovingt...cess-2007.aspx

There are four new macro actions associated with TempVars:
(1) TempVars![Name]returns the variant value that was stored.
(2) SetTempVars(Name, Expression) allows macros to set a TempVar to a given value.
(3) RemoveTempVars(Name) removes the TempVar from the store.
(4) RemoveAllTempVars empties the TempVars store.

My book and Help all mentioned everything but the TempVars![Name] part. This does the trick. Hope this helps someone else.