Good morning,
I am trying to find if it is possible to update some closed excel files with a macro. Here is what I want to do:
I have 20 excel files I update with analytics canvas (an external software). Let's call them Ax. ( A1, A2, A3,...., A20). Each month I update these files (I get 20 new files from analytics canvas and that I save over the A1 for instance, in order to keep the same source file.
Then I created 20 excel files, let's call them Bx (B1, B2, B3,..., B20) - and each one is linked to one of the 20 from analytic canvas (A1 is linked to B1, A2 is linked to B2, ....A20 is linked to B20). The link is just a formula in the Bx file looking to a cell in Ax.
Every month I have to update each B file.
In theory, I will open the file A1, and B1. Then update the links and close both of them.
I have 40 files so it is a little bit long...
I would like to know if we can create a macro (in another excel file for instance) to update each B file without opening neither A or B. (I would create a macro for each file)
the name of each file do not change.
Thank you very much in advance for your help.
Bookmarks