If you have a set of workbooks that are all open at the same time, just
assign some cell in one of the workbooks to hold the variable. This way VBA
can retrieve/modify the variable just like any other cell.

An alternative is to assign some registry key to hold the variable and use
savesetting/getsetting
--
Gary''s Student - gsnu200810