global 'path' declaration
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
|