How do I pass value from a worksheet to set a parameter field?
Unfortunately this isn't possible in Tableau 7.
It is however the second highest voted feature request in the ideas section so it might appear in future releases. You may want to participate in the thread:
Retrieving data ...