Pushing Updates to Multiple Excel Files That have The same Layout

Question

I am the owner of&nbsp; file used by Mutiple locations throughout the US that all have the same exact same layout but have different data connections to each of the individual locations. When an update is requested, it becomes a very cumbersome task to update all of the files. I hoping someone has dealt with a similar situation before and was hoping there is a way to "publish" updates and then push them to all of the workbooks. Maybe make a change to a master copy and run a script to update the rest.&nbsp;Thank you all in advance!

kidd_ip · Answer

VBA may help:
&nbsp;
Sub UpdateFiles()
    Dim MyDir As String, NextFile As String
    MyDir = "C:\Path\To\Your\Files\" ' Update with your directory path
    NextFile = Dir(MyDir &amp; "*.xlsx")
    While NextFile &lt;&gt; ""
        Workbooks.Open (MyDir &amp; NextFile)
        ' Apply your updates here
        Workbooks(NextFile).Save
        Workbooks(NextFile).Close
        NextFile = Dir()
    Wend
End Sub
&nbsp;

thechameleon · Answer

Thank you! I will give it a try&nbsp;

Forum Discussion

Pushing Updates to Multiple Excel Files That have The same Layout

Resources