Excel file which gets updated

[Monica85]

I have a folder, where i save all excel files and another file (Update.xlsx), which gets updated, whenever a new file is saved.

How can that be done?

[AndyLitch]

My approach would be to :-
1. Save the Update.xlsx to Update.xlsm so it can hold macros.
2. Write a file listing macro in the update workbook.
3. Use Application.Ontime in the Update workbook to periodically refresh the file list...

[Monica85]

Help me plz. I am new to macroprogramming

[AndyLitch]

Here's stage one......... A workbook with a manual folder listing macro.

I've set it up to list the files automatically whenever the workbook is opened or activated so there may be no need to update at time intervals.

FolderMonitor.xlsm

[Monica85]

In which folder should the macro file be saved in?