Hi all

i need to have a global 'path' that all of my functions and subs have access
to, so that if i want to change the path, i need to change it only in one
place

i have

const docPath="C:\Temp\"

defined in ThisWorkbook, but when i open the workbook and run any of my
functions trying to reference docPath, it is empty

is defining it as a const in ThisWorkbook not setting it public?
or do i need to do

public docPath

Private Sub Workbook_Open()
docPath = "C:\Temp\"
End Sub

?

doesn't that allow the path to be changed from other functions?

any suggestions greatly appreciated!

thanks!

J