Share VBA variable in multiple templates
Hi,
I am not an office or VBA expert. I am required to migrate our existing Word 2003 template to work with Word 2007 on Windows 7. Currently we have a common template in Word startup folder which contains the custom toolbars and related macros. All the other Word templates are stored on a network location. There is a .ini file which is read by templates for some configuration values. As part of migration, IT has decided to move the templates to a more appropriate location. The problem is, the path to the .ini file is hardcoded in the common template and hundreds of other templates. So I was wondering if there is a way to get the path to .ini file from common template to the other templates to use, so that the hardcoding is just at one location (common template). As a test, I tried adding a reference to common template in one of the other templates and the template started throwing 'name conflict' errors as a result. Can anyone suggest a solution by which I can have the hardcoded path in one location and available to all other templates? Any help would be highly appreciated.
Thanks in advance
Shameer
|