Updating list of all files in a folder

[Mark.jpl]

Hello,

I'm not that well versed in VBA so please help!

I have a MASTER workbook and other TEMPLATE workbooks (Template1, Template2), in the same folder, however, this folder will change dependent on the project I am working on (C:\ProjectA, C:\ProjectB, etc.) and as such I think the code will have to refer to the MASTER workbook current location.

I need a piece of code that will list all excel files within the folder on Sheet2 of the MASTER workbook and update each time the master workbook is opened.


Thanks,
Mark

[davegugg]

Put the following code in the Workbook_Open event of the Master workbook.

Please Login or Register  to view this content.

[Mark.jpl]

Thanks for that but all that happens when the Master file is opened is Cell A1 on Sheet2 has "Other workbooks in this directory." and there is no list below it, any ideas?

I have both .xls and .xlms spreadsheets I need to list, I don't know if that makes a difference?

Thanks.

[davegugg]

I've updated the code to include .xlsx and .xlsm.

[Mark.jpl]

Thanks a lot! It works perfectly!