Static data for directory

[kckay]

I have multiple VBA modules that all refer to directories on the local machine and across the network.

I am currently defining the directories in each module.

How can I define them once and then refer to them in any module?

Set Word_Template_Name = "Sanitary Survey Template.dotx"
Set Excel_Template_Name = "Sanitary Survey Blank.xlsm"
Set WQCDdir = "c:\CO Sanitary Survey\"
Set WQCD_Source_Dir_File = "...\wqc\Programs\SDW\Engineering\Templates\"

This would ensure that any directory changes could be made once rather than 5 times.

 

[Zack Barresse]

Use a standard module and use a public constant...

Public MyVariableString As String = "Your variable text here"

HTH