Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-05-2010, 08:37 PM
shameerau shameerau is offline Share VBA variable in multiple templates Windows 7 Share VBA variable in multiple templates Office 2007
Novice
Share VBA variable in multiple templates
 
Join Date: Jul 2010
Posts: 4
shameerau is on a distinguished road
Default 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
Reply With Quote
Reply

Tags
share vba variable



Similar Threads
Thread Thread Starter Forum Replies Last Post
Share Workbook cannot merge Ichigo Excel 3 01-19-2010 03:05 AM
Share VBA variable in multiple templates share content between documents? albytrott Word 1 10-08-2009 08:27 AM
Inputting variable data axy Word 0 09-08-2009 04:50 PM
How to 'share' a section between two documents JohnA Word 0 08-26-2009 05:47 AM
Share VBA variable in multiple templates Find and Replace - Variable change Ssendam Excel 1 07-16-2009 11:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft