Good day, I wanted to know if it is possible to declare a variable at the
application level. In other words, as a workbook opens it sets the value of
a variable so that all other workbooks can use that value without have to
declare it in each workbook.

ie;

worbook1 opens and declares variable X as "\\mypath\"

as worbook2 opens, it has code that will have the X variable in it and
should know that X is "mypath" without declaring it in workbook2