Config file to control matching variables across .xlsm files?

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,671
Office Version
365
Platform
Windows
Hi,

I have 11 parent .xlsm files and unknown number of child .xlsm files.

Each parent file has a year variable
Each child file has a date variable, a year variable and a string variable.

Year variable is same value across all files
Each child file has the same value variable

A user needs to control and update these variables across all files; at present there are 3 variables that require updating globally, but may reach 9.

What would be easiest way to make these variable change updates across all files?

I do not want to modify any registry files, but haven't used config files, .ini files etc - they appear to be a CSV equivalent that is loaded into each file when they open?

File structure equivalent is: Folder <variable name="">

\Year\<year>Area\11 parent.xlsm files

<year>\Year\Client\Client_1<client_1] child1.xlsm="" file
<year>\Client_1.xlsm
<year>\Year\Client\Client_2<client_1] child1.xlsm="" file
<year>\Client_2.xlsm</year></client_1]></year><client_2] child2.xlsm="" file

<year>\Year\Client\Client_x<client_1] child1.xlsm="" file
<year>\Client_x.xlsm
</year></client_1]></year>
<year><client_x] childx.xlsm="" file

Any suggestions please?

TIA,
Jack</client_x]></year></client_2]></year></client_1]></year></year></variable>
 
Last edited:

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,099,834
Messages
5,471,062
Members
406,741
Latest member
mkpog

This Week's Hot Topics

Top