Updating Multiple Workbooks from one Master Workbook without opening each individually

Hi Folks
I have around 35 separate Workbooks that all update from one Master Workbook.
Is it possible to update each of those 35 Workbooks without literally opening each one individually?

Cheers
hammer

It is, to my opinion, not possible to add new data in a closed workbook.

In a VBA code, it is possible not showing opening the workbook.

But you don't add the VBA code so that is difficult to tell.

(p.s. i'm not good enough with VBA to solve your question)

Hi oeldere
The Code to do this is actually what I am seeking.
Cheers
hammer

you can use DIR to open every file in a folder

Please Login or Register  to view this content.

Every Workbook feeds from one Master by =A2 etc into the first sheet
So the rows are just pulled down every so often to cover the data/rows in the Master.

One other Workbook gives a snapshot of certain cells in all the others.

At the moment I have to open each individually for them to update which is tedious.

After reading around I have placed 5 files into a Workplace file
While this opens the five files I still get the prompt to update each file individually.
Is there some Code to auto update all files automatically on opening?
Cheers

bulina2k my Folder name is UPDATEPLANS and is in D: Drive
The file I would drop the Code in is 'DAILY CARDS and BSP Results.xlsm' also in D:

Could you show me how they fit in your Code and also what does 'your code here' mean/need?
Thanks
hammer

Further, some files have different extensions eg .xlsm .xlsx which I also need to cover in the Code?

Bump oh and Bump to get the min amount of letters in

Can you upload "DAILY CARDS and BSP Results.xlsm" ? (Remove sensible/confidential data first)

Hi bulina2k
Unfortunately it is quite a large file.
"D:\DAILY CARDS and BSP Results.xlsm" that is the target it gives for it under Properties.

Closing this thread and will start a new one as my requirement has changed.