maybe someone can tell me if this is a bad idea, too.

i use a public variable to set the path and set it in the workbook open module
to keep from setting the path in 12 different modules.
Public fPath As String is in a standard module

If UCase(Environ("username")) = "GARYK" Then
fPath = ThisWorkbook.Path & "\Blends\"
Else
fPath = "\\Customers\Blends\"
End If
is in the workbook open module

i noticed i was losing the path, it was resetting to an empty string. what
caused it was going to the module with the public variables, making a change and
recompiling. even if i just deleted a space, it still reset the variable,

so my question is: is this a bad idea and will this ever reset during the course
of normal operation for my client? they never enter the vbe.



--


Gary