Hi,
I am new to VBA so please bear with me!!
I have 3 excel files. File1 contains the raw data. File2 contains links to file1 to put it into the required format. File3 contains links to File2 to present the data. Due to a number of reasons this is the file structure that we need to maintain.
The problem that I have is when I access File3 I need to click a command button that updates the data links between File1 & 2, and then File2 & 3. I don't want to manaully open File1 & 2 to update the links.
Any help or suggestions on what the VBA code is will be greatly appreciated.
Many thanks in advance.
I am new to VBA so please bear with me!!
I have 3 excel files. File1 contains the raw data. File2 contains links to file1 to put it into the required format. File3 contains links to File2 to present the data. Due to a number of reasons this is the file structure that we need to maintain.
The problem that I have is when I access File3 I need to click a command button that updates the data links between File1 & 2, and then File2 & 3. I don't want to manaully open File1 & 2 to update the links.
Any help or suggestions on what the VBA code is will be greatly appreciated.
Many thanks in advance.
