When I need to refer to information that the user can change, I utilize
specific cells for variable values.

For example:
You could use cell A1 to input the date and have your code reference this
cell to fill a variable with that value.

Would something like this suffice?

Mark Ivey



"kdw" wrote in message
...
I am using a 3 party vendor software where I have limited access to
Excel's
object model, but I need to be able to programmically change some page
settings. Is there a way to embed some VBA code in like a cell or
something
and then have Excel run those codes somehow?

What other choices do I have?

Thanks.
kdw