Is it possible to use a Public Variable (created in a macro) in a cell
formula?

Specifically: I have a workbook that contains a date as a part of the name
(id MySheet 11.10.03.xls)
When I open the workbook I capture the date (11/10/03) into a Public
Variable "ThisWeek". I want to use that
variable in a cell calculation. Is that possible? When I use the formula
=if(E3<ThisWeek, "Not Started", "Started"),
I get #NAME# in the cell

TIA
Glen